On Wed, Sep 12, 2012 at 8:27 PM, Ben Chobot <be...@silentmedia.com> wrote: > In an attempt to get a hackfix for > http://pgfoundry.org/tracker/index.php?func=detail&aid=1011203&group_id=1000411&atid=1376, > I'm wonder if it's true that, when looking at pg_locks, the only pid which > will have virtualxid = '1/1' and virtualtransaction = '-1/0' will be the > bgwriter. That seems correct on all my dbs, but that's hardly a definitive > test.
Just stumbled upon the same issue. You got no reply here... maybe it's worth contacting -hackers about it. I've tried googling around and found no discussion about the bgwriter keeping that lock, except your message. Good luck, cheers! -- Daniele -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general