On Tue, Jul 28, 2009 at 5:21 PM, Greg Smith<gsmith@xxxxxxxxxxxxx> wrote: > On Tue, 28 Jul 2009, Scott Marlowe wrote: > >> Just FYI, I ran the same basic test but with -c 10 since -c shouldn't >> really be greater than -s > > That's only true if you're running the TPC-B-like or other write tests, > where access to the small branches table becomes a serious hotspot for > contention. The select-only test has no such specific restriction as it I thought so too, but my pgbench -S -c 16 was WAY faster on a -s 16 db than on a -s10... -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
