| From: | Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Pre-allocated free space for row updating (like PCTFREE) |
| Date: | 2005-08-22 00:01:13 |
| Message-ID: | 430915C9.20505@nttdata.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
I've done a quick hack to implement PCTFREE on PostgreSQL.
As you know, it's inspired by Oracle's PCTFREE.
http://www.csee.umbc.edu/help/oracle8/server.815/a67772/schema.htm#990
http://www.comp.hkbu.edu.hk/docs/o/oracle10g/server.101/b10743/cncpt031.gif
Pre-allocated space for each block(page) can improve heap_update() performance,
because heap_update() looks for the free space in same block
to insert new row.
According to my experiments, pgbench score was improved 10% or more
with 1024 bytes free space.
Any comments? Is this idea good, or not?
Thanks.
--
NAGAYASU Satoshi <nagayasus(at)nttdata(dot)co(dot)jp>
| Attachment | Content-Type | Size |
|---|---|---|
| pctfree.001.diff | text/plain | 9.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-08-22 00:08:22 | Re: [HACKERS] PostgreSQL 8.0.3 and Ipv6 |
| Previous Message | Dave Page | 2005-08-21 23:28:25 | Re: Sleep functions |
