On Wed, Jul 13, 2011 at 08:40, Craig Ringer <cr...@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/ <http://www.postnewspapers.com.au/> >