Re: Low Budget Performance, Part 2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eric soroos <eric-psql(at)soroos(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Low Budget Performance, Part 2
Date: 2002-11-27 19:19:22
Message-ID: 21018.1038424762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

eric soroos <eric-psql(at)soroos(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message eric soroos 2002-11-27 20:45:39 Re: Low Budget Performance, Part 2
Previous Message eric soroos 2002-11-27 18:51:02 Low Budget Performance, Part 2