[PATCHES] BTree vacuum before page splitting

Hi all, This patch adds a function to remove unnecessary items before split page of BTree. When a new item is put in the page, it looks for the "LP_DELETE" item, and removes that item. No heap access is required. Moreover, the penalty is also few because it operates instead of page split. Only w

[PATCHES] Patch for ALTER TABLE / TYPE

Hi, Please find the patch attached. This is for the bug which is posted to hackers before. http://archives.postgresql.org/pgsql-hackers/2005-06/msg01442.php We can see a problem by this bug in following way. CREATE TABLE pktable (a int primary key); CREATE TABLE fktable (b int references pktabl

Re: [PATCHES] BTree vacuum before page splitting

Junji TERAMOTO <[EMAIL PROTECTED]> writes: > This patch adds a function to remove unnecessary items before split > page of BTree. > When a new item is put in the page, it looks for the "LP_DELETE" item, > and removes that item. I think this is quite likely to break things :-(. What sort of condi

Re: [PATCHES] Patch for ALTER TABLE / TYPE

NAKANO Yoshihisa <[EMAIL PROTECTED]> writes: > Please find the patch attached. This is for the bug which is posted to > hackers before. > http://archives.postgresql.org/pgsql-hackers/2005-06/msg01442.php > We can see a problem by this bug in following way. > CREATE TABLE pktable (a int primary k