On Tue, Jul 28, 2009 at 5:21 PM, Greg Smith<gsm...@gregsmith.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to