Re: Adding a pgbench run to buildfarm

Tom Lane wrote:
> "Bort, Paul" <pbort@tmwsystems.com> writes:
>> Andrew said I should solicit opinions as to what parameters to use. A
>> cursory search through the archives led me to pick a scaling factor of
>> 10, 5 users, and 100 transactions.
> 
> 100 transactions seems barely enough to get through startup transients.
> Maybe 1000 would be good.
> 

Scale factor 10 produces an accounts table of about 130 Mb. Given that 
most HW these days has at least 1G of ram, this probably means not much 
retrieval IO is tested (only checkpoint and wal fsync). Do we want to 
try 100 or even 200? (or recommend scale factor such that size > ram)?

Cheers

Mark