| From: | Tony Wang <wwwjfy(at)gmail(dot)com> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Weird problem that enormous locks |
| Date: | 2011-07-13 03:29:52 |
| Message-ID: | CAH1z_A5v36fvxt17rFhsMFGSLKjXM80==3UaUwnVuSX2v5uOoA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 13, 2011 at 08:40, Craig Ringer <craig(at)postnewspapers(dot)com(dot)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/ <http://www.postnewspapers.com.au/>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sim Zacks | 2011-07-13 05:08:30 | Re: Alter Columns with Triggers |
| Previous Message | Craig Ringer | 2011-07-13 00:40:14 | Re: Weird problem that enormous locks |