Re: Stuck in "DELETE waiting"

From: Alexander Staubo <alex(at)purefiction(dot)net>
To: Jerry Sievers <jerry(at)jerrysievers(dot)com>
Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stuck in "DELETE waiting"
Date: 2006-11-24 11:02:36
Message-ID: 8CED4483-8F43-4979-86B2-97FC0FCE8E02@purefiction.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 24, 2006, at 01:37 , Jerry Sievers wrote:

> Have a look at the query_start field in pg_stat_activity for the
> process holding locks that's causing backlog.

Doesn't this require "stats_command_string = on"? I don't have that
enabled on production servers.

Alexander.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-11-24 12:01:07 Re: IN clause
Previous Message Jakub Ouhrabka 2006-11-24 10:59:16 vacuum: out of memory error