Horton

Re: Lock problem with autovacuum truncating heap

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Jan Wieck <JanWieck@yahoo.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Itagaki Takahiro <itagaki.takahiro@gmail.com>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2011-03-27T22:21:20Z
Lists: pgsql-hackers 
On Sun, Mar 27, 2011 at 3:25 PM, Jan Wieck <JanWieck@yahoo.com> wrote:
> Since we are talking about stable releases, I think just releasing and
> reacquiring the exclusive lock is enough. We can then try to further improve
> things for future releases.

That seems unsafe - things can change under you while you don't hold the lock...

I kind of like the idea of committing the transaction and then
beginning a new one just to do the truncation.  Given the way the
deadlock detector treats autovacuum, the current coding seems quite
risky.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company