Home > mailing lists

Postgres log configuration for locking - Mailing list pgsql-admin

From	Raj Gandhi
Subject	Postgres log configuration for locking
Date	December 3, 2014 23:08:03
Msg-id	CALU_HCOwRjbpbH1yg71nqOV4Fc1HkK6Bj1rdBS2p2hs4gT=EuQ@mail.gmail.com Whole thread Raw
Responses	Re: Postgres log configuration for locking
List	pgsql-admin

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

From: Vasilis Ventirozos
Date: 03 December 2014, 13:07:05
Subject: Re: WAL log management w/ multiple slaves

From: Jerry Sievers
Date: 04 December 2014, 00:26:28
Subject: Re: Postgres log configuration for locking