Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2013
    Posts
    2

    Unanswered: SSD to improve performance

    Hi guys.
    my first post on this forum and I ask a very newbie question: how can I improve the performance of my database using an SSD? Which part of the db should I move on this disk? And how?

    Thanks in advance

  2. #2
    Join Date
    Dec 2013
    Posts
    2
    noone??

  3. #3
    Join Date
    Apr 2011
    Posts
    34
    did you try PGDATA?
    What OS are you using? Assuming you are on *nix you could put PGDATA on it's own partition. I did not have good experience with SSDs. Actually had one, it died so I went back to good old spinning HD.

  4. #4
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Your question is equivalent to asking:

    "If I put a turbo on my car, will it be better?"

    We don't know what your database is doing and or where your performance issue lies. You give us no details about the size of your database, current configuration, performance requirements, etc etc etc...so the simple answer to your question is 'sure, why not'. SSD's are better (not to mention way cooler) in general than traditional platter drives but w/o knowing what you're doing or what you have, there's no right answer here.

  5. #5
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •