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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [ADMIN] v7.1b4 bad performance
Дата
Msg-id 25499.982602903@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: [ADMIN] v7.1b4 bad performance  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: floating point representation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: GET DIAGNOSTICS (was Re: Open 7.1 items)