From:
Greg Smith <greg(at)2ndquadrant(dot)com>
To:
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc:
Merlin Moncure <mmoncure(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:10:47
Message-ID:
4B05B457.90507@2ndquadrant.com (view raw or flat )
Thread:
2009-11-13 12:46:15 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-13 13:02:34 from Karl Denninger <karl(at)denninger(dot)net>
2009-11-13 13:57:34 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-20 11:06:05 from Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
2009-11-20 18:59:57 from Richard Neill <rn214(at)cam(dot)ac(dot)uk>
2009-11-21 00:27:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-21 14:25:03 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-13 14:07:28 from Marcos Ortiz Valmaseda <mlortiz(at)uci(dot)cu>
2009-11-13 14:48:05 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2009-11-13 15:29:43 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-13 17:22:17 from Scott Carey <scott(at)richrelevance(dot)com>
2009-11-13 18:31:29 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-13 15:36:51 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-11-13 15:59:03 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-14 11:17:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-11-14 13:05:25 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-14 13:47:06 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-11-14 21:30:39 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-14 15:09:36 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-14 20:03:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-15 02:09:51 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-13 17:21:28 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-13 17:35:34 from Karl Denninger <karl(at)denninger(dot)net>
2009-11-13 18:07:39 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-13 18:21:19 from Karl Denninger <karl(at)denninger(dot)net>
2009-11-19 04:06:42 from Scott Carey <scott(at)richrelevance(dot)com>
2009-11-19 04:24:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-20 16:47:01 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2009-11-19 14:44:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-19 14:44:58 from Karl Denninger <karl(at)denninger(dot)net>
2009-11-13 19:24:16 from Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
2009-11-13 20:22:22 from Dave Crooke <dcrooke(at)gmail(dot)com>
2009-11-13 21:06:20 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-13 21:09:18 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-17 16:36:26 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-17 16:54:42 from Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
2009-11-17 17:04:11 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2009-11-17 17:30:13 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-11-17 18:51:13 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-17 19:19:35 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-18 06:32:01 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-18 06:58:42 from david(at)lang(dot)hm
2009-11-19 04:39:02 from Scott Carey <scott(at)richrelevance(dot)com>
2009-11-19 17:01:20 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-19 17:19:32 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2009-11-19 21:10:47 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-19 21:39:18 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-19 21:52:08 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2009-11-17 20:09:58 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2009-11-19 04:35:02 from Scott Carey <scott(at)richrelevance(dot)com>
2009-11-19 14:49:08 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-28 16:20:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-11-30 00:46:33 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2009-11-30 03:09:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-11-30 05:12:41 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-30 12:08:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-11-30 16:32:34 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2009-11-30 16:40:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-11-30 15:48:32 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2009-11-13 18:57:28 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2009-11-13 21:35:57 from "Kenny Gorman" <KGorman(at)hi5(dot)com>
2009-11-18 22:59:36 from Kenny Gorman <kgorman(at)hi5(dot)com>
2009-12-08 14:22:17 from Matthew Wakeling <matthew(at)flymine(dot)org>
2010-02-20 18:28:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-20 23:07:16 from Dan Langille <dan(at)langille(dot)org>
2010-02-20 23:19:03 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-21 09:34:42 from Scott Carey <scott(at)richrelevance(dot)com>
2010-02-21 14:10:43 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-21 14:54:24 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-02-22 05:39:06 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-02-22 07:10:55 from Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
2010-02-23 01:04:35 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-02-23 01:11:26 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2010-02-23 01:39:33 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-02-23 02:21:40 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2010-02-23 02:22:56 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2010-02-23 11:49:52 from "Pierre C" <lists(at)peufeu(dot)com>
2010-02-23 12:07:24 from Nikolas Everett <nik9000(at)gmail(dot)com>
2010-02-23 18:36:56 from Scott Carey <scott(at)richrelevance(dot)com>
2010-02-22 14:37:13 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-22 18:00:34 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-02-23 01:14:47 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-02-23 08:23:25 from david(at)lang(dot)hm
2010-02-23 19:35:46 from david(at)lang(dot)hm
2010-02-23 20:34:35 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-02-23 21:22:16 from david(at)lang(dot)hm
2010-02-23 21:32:13 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2010-02-24 08:32:40 from Dave Crooke <dcrooke(at)gmail(dot)com>
2010-02-27 01:40:18 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-27 19:38:20 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-02-27 20:16:33 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-28 04:05:16 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-02-28 05:06:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-03-02 03:34:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-02 03:33:53 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-02 06:13:29 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-03-03 15:16:40 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2010-03-02 08:36:48 from "Pierre C" <lists(at)peufeu(dot)com>
2010-02-22 14:39:55 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-11-13 20:57:38 from "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
2009-11-13 21:09:59 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-14 09:30:43 from Lists <lists(at)on-track(dot)ca>
2009-11-14 10:42:45 from Ivan Voras <ivoras(at)freebsd(dot)org>
2009-11-15 03:57:06 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-15 08:46:56 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2009-11-15 06:05:12 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-15 10:17:24 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2009-11-15 08:15:43 from Laszlo Nagy <gandalf(at)shopzeus(dot)com>
2009-11-15 19:53:22 from Craig James <craig_james(at)emolecules(dot)com>
2009-11-15 20:42:24 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-11-19 04:22:29 from Scott Carey <scott(at)richrelevance(dot)com>
2009-11-19 12:29:56 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2009-11-19 18:01:14 from Anton Rommerskirchen <atr(at)atrsoft(dot)de>
2009-11-19 18:57:51 from Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
2009-11-19 21:04:29 from Greg Smith <greg(at)2ndquadrant(dot)com>
2009-11-20 11:54:58 from Matthew Wakeling <matthew(at)flymine(dot)org>
2009-12-04 00:04:32 from Scott Carey <scott(at)richrelevance(dot)com>
Lists:
pgsql-performance
Scott Marlowe wrote:
> On Thu, Nov 19, 2009 at 10:01 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>
>> pgbench is actually a pretty awesome i/o tester assuming you have big
>> enough scaling factor
> Seeing as how pgbench only goes to scaling factor of 4000, are the any
> plans on enlarging that number?
>
I'm doing pgbench tests now on a system large enough for this limit to
matter, so I'm probably going to have to fix that for 8.5 just to
complete my own work.
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.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
In response to
Responses
pgsql-performance by date
Next :From: Merlin MoncureDate: 2009-11-19 21:39:18Subject : Re: SSD + RAIDPrevious :From : Greg SmithDate : 2009-11-19 21:04:29Subject : Re: SSD + RAID
