Re: [GENERAL] locks held during commit with synchronous replication

2013-10-22 Thread Torsten Förtsch
On 21/10/13 20:46, Tom Lane wrote: > =?ISO-8859-1?Q?Torsten_F=F6rtsch?= writes: >> > I noticed that with synchronous replication I often see locks like this: >> > [ AccessExclusiveLock on "database 0" ] > You did not say what PG version you're talking about, but if it's recent It's 9.3.1 > then

Re: [GENERAL] locks held during commit with synchronous replication

2013-10-21 Thread Tom Lane
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= writes: > I noticed that with synchronous replication I often see locks like this: > [ AccessExclusiveLock on "database 0" ] You did not say what PG version you're talking about, but if it's recent then this must be coming from PreCommit_Notify, which takes such

[GENERAL] locks held during commit with synchronous replication

2013-10-21 Thread Torsten Förtsch
Hi, I noticed that with synchronous replication I often see locks like this: -[ RECORD 10 ]-+ locktype | object database | 0 relation | page | tuple | virtualxid | transactionid | classid| 12