bgwriter and pg_locks

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: bgwriter and pg_locks
Date: 2012-09-12 19:27:16
Message-ID: A4EEC6EC-2D6C-40FA-9D7C-FD4A1DAB4EEA@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry C. 2012-09-12 19:54:57 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Previous Message Tom Lane 2012-09-12 19:24:04 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch