Re: SSD performance - Mailing list pgsql-performance

From David Rees
Subject Re: SSD performance
Date
Msg-id 72dbd3150902031026t381d42dreeddcfa746526be3@mail.gmail.com
Whole thread Raw
In response to Re: SSD performance  (Jeff <threshar@torgo.978.org>)
List pgsql-performance
On Tue, Feb 3, 2009 at 9:54 AM, Jeff <threshar@torgo.978.org> wrote:
> Scalefactor 50, 10 clients: 900tps
>
> At scalefactor 50 the dataset fits well within memory, so I scaled it up.
>
> Scalefactor 1500: 10 clients: 420tps
>
> While some of us have arrays that can smash those numbers, that is crazy
> impressive for a plain old mirror pair.   I also did not do much tweaking of
> PG itself.
>
> While I'm in the testing mood, are there some other tests folks would like
> me to try out?

How do the same benchmarks fair on regular rotating discs on the same
system?  Ideally we'd have numbers for 7.2k and 10k disks to give us
some sort of idea of exactly how much faster we're talking here.  Hey,
since you asked, right? ;-)

-Dave

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Deleting millions of rows
Next
From: Scott Carey
Date:
Subject: Re: SSD performance