Re: [GENERAL] bgwriter and pg_locks

2012-09-17 Thread Daniele Varrazzo
On Wed, Sep 12, 2012 at 8:27 PM, Ben Chobot 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 vi

[GENERAL] bgwriter and pg_locks

2012-09-12 Thread Ben Chobot
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