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
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-hackers by date
|Next:||From: Jim C. Nasby||Date: 2005-12-22 20:03:43|
|Subject: Re: Automatic function replanning|
|Previous:||From: Andrew Sullivan||Date: 2005-12-22 18:59:38|
|Subject: Re: Does VACUUM reorder tables on clustered indices|