Skip site navigation (1) Skip section navigation (2)

Re: Unsplitting btree index leaf pages

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unsplitting btree index leaf pages
Date: 2005-12-22 20:03:20
Message-ID: 20051222200320.GC23918@surnet.cl (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2005-12-22 20:03:43
Subject: Re: Automatic function replanning
Previous:From: Andrew SullivanDate: 2005-12-22 18:59:38
Subject: Re: Does VACUUM reorder tables on clustered indices

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group