From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: wal_synch_method = open_sync safe on RHEL 5.5?
Date: Fri, 18 Jun 2010 16:19:52 +1200
Message-ID: <4C1AF3E8.4030608@catalyst.net.nz> (raw)
In-Reply-To: <4C1AE820.6020506@2ndquadrant.com>
References: <4C1ACE5F.1080802@catalyst.net.nz>
<4C1AE820.6020506@2ndquadrant.com>
On 18/06/10 15:29, Greg Smith wrote:
>
> P.S. Be wary of expecting pgbench to give you useful numbers on a
> single run. For the default write-heavy test, I recommend three runs
> of 10 minutes each (-T 600 on recent PostgreSQL versions) before I
> trust any results it gives. You can get useful data from the
> select-only test in only a few seconds, but not the one that writes a
> bunch.
>
Yeah, I did several runs of each, and a couple with -c 128 and -t 100000
to give the setup a good workout (also 2000-2400 tps, nice to see a well
behaved SAN).
Cheers
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz
Subject: Re: wal_synch_method = open_sync safe on RHEL 5.5?
In-Reply-To: <4C1AF3E8.4030608@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox