Re: Changes improve the performance of INSERT and UPDATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroki Kataoka <kataoka(at)interwiz(dot)koganei(dot)tokyo(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Changes improve the performance of INSERT and UPDATE
Date: 2005-07-17 05:37:31
Message-ID: 25457.1121578651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hiroki Kataoka <kataoka(at)interwiz(dot)koganei(dot)tokyo(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroki Kataoka 2005-07-17 06:03:39 Re: Changes improve the performance of INSERT and UPDATE
Previous Message Tom Lane 2005-07-17 04:54:14 Re: Changes improve the performance of INSERT and UPDATE