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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
