Re: Changes improve the performance of INSERT and UPDATE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Changes improve the performance of INSERT and UPDATE
Дата
Msg-id 25457.1121578651@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Changes improve the performance of INSERT and UPDATE  (Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>)
Ответы Re: Changes improve the performance of INSERT and UPDATE  (Hiroki Kataoka <kataoka@interwiz.jp>)
Список pgsql-hackers
Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp> writes:
> This small patch improves the performance of INSERT and UPDATE.  By my
> machine, these changes raised the performance about 5%~10% in pgbench.

BTW, in profiling the backend I've never seen PageAddItem take more than
about 1% of the runtime, and in pgbench in particular it seems to be
down around 0.1% ... so the above seems a bit optimistic ...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Changes improve the performance of INSERT and UPDATE
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Buildfarm issues on specific machines