Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird problem that enormous locks - Mailing list pgsql-general

From Tony Wang
Subject Re: Weird problem that enormous locks
Date
Msg-id CAH1z_A5v36fvxt17rFhsMFGSLKjXM80==3UaUwnVuSX2v5uOoA@mail.gmail.com
Whole thread Raw
In response to Re: Weird problem that enormous locks  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view
On Wed, Jul 13, 2011 at 08:40, Craig Ringer <craig@postnewspapers.com.au> wrote:
On 13/07/2011 12:52 AM, Tony Wang wrote:
Have any one experienced that, or any suggestion on researching/debugging?

Capture the contents of pg_catalog.pg_stat_activity whenever your cron job notices high lock counts. That'll give you some more information to work with.

Thanks, but the cron job query has already joined pg_stat_activity table
 

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Weird problem that enormous locks
Next
From: Sim Zacks
Date:
Subject: Re: Alter Columns with Triggers