Re: FSM search modes - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: FSM search modes
Date
Msg-id 20091001155609.GD5607@alvh.no-ip.org
Whole thread Raw
In response to Re: FSM search modes  (decibel <decibel@decibel.org>)
Responses Re: FSM search modes
List pgsql-hackers
decibel wrote:

> So while something that makes it easier to clean out the end of a
> table would be good, I think the critical need is a way to make
> vacuum more aggressive about obtaining the exclusive lock.

I wonder if we should have a different mode of operation that only
attempted the truncate (say VACUUM TRUNCATE), optionally being
non-conditional about obtaining the required lock.  That said, I wonder
even more whether any such hacks are still needed after the visilibity
map that changed the landscape for vacuum so dramatically.

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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Limit allocated memory per session
Next
From: Tom Lane
Date:
Subject: Re: FSM search modes