Postgres Pro
Downloads
Home   >   mailing lists

bgwriter and pg_locks - Mailing list pgsql-general

From Ben Chobot
Subject bgwriter and pg_locks
Date
Msg-id A4EEC6EC-2D6C-40FA-9D7C-FD4A1DAB4EEA@silentmedia.com
Whole thread Raw
Responses Re: bgwriter and pg_locks  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List pgsql-general
Tree view 
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,
whenlooking 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Next
From: "Henry C."
Date:
Subject: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch