On Sun, Mar 27, 2011 at 3:25 PM, Jan Wieck <janwi...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
