Skip site navigation (1) Skip section navigation (2)

Re: SSD + RAID

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Scott Carey <scott(at)richrelevance(dot)com>, "david(at)lang(dot)hm" <david(at)lang(dot)hm>, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>, Karl Denninger <karl(at)denninger(dot)net>, Laszlo Nagy <gandalf(at)shopzeus(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SSD + RAID
Date: 2009-11-19 21:39:18
Message-ID: b42b73150911191339j2ab62c1bu9042ea08a6f142e0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Nov 19, 2009 at 4:10 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> You can use pgbench to either get interesting peak read results, or peak
> write ones, but it's not real useful for things in between.  The standard
> test basically turns into a huge stack of writes to a single table, and the
> select-only one is interesting to gauge either cached or uncached read speed
> (depending on the scale).  It's not very useful for getting a feel for how
> something with a mixed read/write workload does though, which is unfortunate
> because I think that scenario is much more common than what it does test.

all true, but it's pretty easy to rig custom (-f) commands for
virtually any test you want,.

merlin

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2009-11-19 21:52:08
Subject: Re: SSD + RAID
Previous:From: Greg SmithDate: 2009-11-19 21:10:47
Subject: Re: SSD + RAID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group