Re: Unsplitting btree index leaf pages - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Unsplitting btree index leaf pages
Date
Msg-id 20051222200320.GC23918@surnet.cl
Whole thread Raw
In response to Re: Unsplitting btree index leaf pages  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Unsplitting btree index leaf pages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Martijn van Oosterhout wrote:

> The downsides are probably that it's a pain to make it work
> concurrently and requires writing each index page at least twice. But
> it's a thought...

We already do something similar for page deletions.  Empty pages are not
deleted right away, but they are marked with BTP_DEAD, and then deleted
on a subsequent vacuum.  Or something like that, I don't remember the
exact details.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and DELETE?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Automatic function replanning