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