Changes improve the performance of INSERT and UPDATE

From: Hiroki Kataoka <kataoka(at)interwiz(dot)koganei(dot)tokyo(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Changes improve the performance of INSERT and UPDATE
Date: 2005-07-17 04:43:13
Message-ID: 42D9E1E1.2070307@interwiz.koganei.tokyo.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

This small patch improves the performance of INSERT and UPDATE. By my
machine, these changes raised the performance about 5%~10% in pgbench.
Please take a benchmark in a reliable environment. Since I may forget
some required changes, I specify that this patch is experimental. But
note that all regression tests have passed.

Thanks,

--
Hiroki Kataoka <kataoka(at)interwiz(dot)jp>

Attachment Content-Type Size
pageadditem.patch text/plain 3.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-07-17 04:43:15 Re: Autovacuum loose ends
Previous Message Hiroki Kataoka 2005-07-17 04:28:30 Changes improve the performance of INSERT and UPDATE