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

From Craig Ringer
Subject Re: Weird problem that enormous locks
Date
Msg-id 4E1CE96E.4030406@postnewspapers.com.au
Whole thread Raw
In response to Weird problem that enormous locks  (Tony Wang <wwwjfy@gmail.com>)
Responses Re: Weird problem that enormous locks
List pgsql-general
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.

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: No suitable driver found for jdbc:postgresql [error]
Next
From: Tony Wang
Date:
Subject: Re: Weird problem that enormous locks