On Wed, Jul 13, 2011 at 08:40, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote:
On 13/07/2011 12:52 AM, Tony Wang wrote: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.
Have any one experienced that, or any suggestion on researching/debugging?
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/
