Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group