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 |