On Wed, Sep 12, 2012 at 8:27 PM, Ben Chobot <bench@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
