Re: Weird problem that enormous locks

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Tony Wang <wwwjfy(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird problem that enormous locks
Date: 2011-07-13 00:40:14
Message-ID: 4E1CE96E.4030406@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Wang 2011-07-13 03:29:52 Re: Weird problem that enormous locks
Previous Message Craig Ringer 2011-07-13 00:33:56 Re: No suitable driver found for jdbc:postgresql [error]