Horton
Menu

Re: [HACKERS] Re: v7.1b4 bad performance

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: "Schmidt, Peter" <peter.schmidt@prismedia.com>, pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org
Date: 2001-02-19T17:15:03Z
Lists: pgsql-hackers 
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> In your test cases I always see "where bid = 1" at "update branches"
> i.e.
>   update branches set bbalance = bbalance + ... where bid = 1

> ISTM there's no multiple COMMIT in your senario-s due to
> their lock conflicts. 

Hmm.  It looks like using a 'scaling factor' larger than 1 is necessary
to spread out the updates of "branches".  AFAIR, the people who reported
runs with scaling factors > 1 got pretty much the same results though.

			regards, tom lane