Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres
Date: 2009-11-05 20:49:29
Message-ID: 2968dfd60911051249k1324e7bva0bd8aba042fceaa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 5, 2009 at 8:46 AM, Howard Cole <howardnews(at)selestial(dot)com> wrote:
> I use a single SSD on one of our servers and it appears to be much more
> responsive than a single 15K SAS drive - Thats as scientific as my testing
> gets! The database I use is mostly reads.
>
> Careful which SSD you choose because there is a wide variation in
> performance.

I have yet to find a anyone that will assert what the write-cycles
these new devices will handle. Our DB is very high write and read
load, and I have no idea how long the SSDs would last. They are still
too expensive for me to buy them to do this experiment.

I certainly hope you have good backups for when your SSD does finally croak.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2009-11-05 21:19:53 Re: Adding a null
Previous Message ara.t.howard 2009-11-05 18:43:22 adding a custom tsearch parser