Postgres Pro
Downloads
Home   >   mailing lists

Postgres log configuration for locking - Mailing list pgsql-admin

From Raj Gandhi
Subject Postgres log configuration for locking
Date
Msg-id CALU_HCOwRjbpbH1yg71nqOV4Fc1HkK6Bj1rdBS2p2hs4gT=EuQ@mail.gmail.com
Whole thread Raw
Responses Re: Postgres log configuration for locking  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-admin
Tree view
I’m using Postgres 9.1 and enabled the log configuration param ‘log_lock_waits’.
 
However, it only logs the session which is waiting for the lock longer than ‘deadlock_timeout’. It doesn’t log the session which acquired the lock? 
 
Is there a way to log the session that acquired the lock along with the session which is waiting for the lock?
 
Thanks,
Raj

 

pgsql-admin by date:

Previous
From: Vasilis Ventirozos
Date:
Subject: Re: WAL log management w/ multiple slaves
Next
From: Jerry Sievers
Date:
Subject: Re: Postgres log configuration for locking