Re: Low Budget Performance, Part 2

eric soroos <eric-psql@soroos.net> writes:
> Running pgbench with: scaling factor=1, # transactions = 100, and
> #clients =1,2,3,5,10,15

The scaling factor has to at least equal the max # of clients you intend
to test, else pgbench will spend most of its time fighting update
contention (parallel transactions wanting to update the same row).

            regards, tom lane