Home > mailing lists

Re: Exhaustive list of what takes what locks - Mailing list pgsql-performance

From	Nikolas Everett
Subject	Re: Exhaustive list of what takes what locks
Date	February 2, 2011 19:30:19
Msg-id	AANLkTinpSW8oAr=tKB2Ahfker1a=7CCRXmmyz5cVSdFP@mail.gmail.com Whole thread Raw
In response to	Re: Exhaustive list of what takes what locks (Nikolas Everett <nik9000@gmail.com>)
Responses	Re: Exhaustive list of what takes what locks
List	pgsql-performance

On Wed, Feb 2, 2011 at 2:53 PM, Nikolas Everett <nik9000@gmail.com> wrote:

Given that the a list would be difficult to maintain, is there some way I can make Postgres spit out the list of what locks are taken?

--Nik

I just answered my own question -

compile with -DLOCK_DEBUG in your src/Makefile.custom and then SET TRACK_LOCKS=true when you want it.

--Nik

From: John Rouillard
Date: 02 February 2011, 19:22:08
Subject: Re: Are we in the ballpark?

From: Mladen Gogala
Date: 02 February 2011, 19:54:35
Subject: Re: [HACKERS] Slow count(*) again...