On Tue, Jul 28, 2009 at 5:21 PM, Greg Smith<gsmith@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...