Re: Re: [ADMIN] v7.1b4 bad performance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: [ADMIN] v7.1b4 bad performance
Date
Msg-id 25499.982602903@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: [ADMIN] v7.1b4 bad performance  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: floating point representation
Next
From: Tom Lane
Date:
Subject: Re: GET DIAGNOSTICS (was Re: Open 7.1 items)