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

[Tom Lane]

Hiroshi Inoue <[EMAIL PROTECTED]> 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