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?= torsten.foert...@gmx.net 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

[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|

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

2013-10-21 Thread Tom Lane
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= torsten.foert...@gmx.net 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