Postgres Pro
Downloads
Home   >   mailing lists

Re: Changes improve the performance of INSERT and UPDATE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Changes improve the performance of INSERT and UPDATE
Date
Msg-id 25457.1121578651@sss.pgh.pa.us
Whole thread Raw
In response to Changes improve the performance of INSERT and UPDATE  (Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>)
Responses Re: Changes improve the performance of INSERT and UPDATE  (Hiroki Kataoka <kataoka@interwiz.jp>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changes improve the performance of INSERT and UPDATE
Next
From: Kris Jurka
Date:
Subject: Re: Buildfarm issues on specific machines