Re: vacuum process is hanging - Mailing list pgsql-general

From Vick Khera
Subject Re: vacuum process is hanging
Date
Msg-id AANLkTimbY-DfRRVe_txKMYLC39nXsQWdkcaVwzz0HNM9@mail.gmail.com
Whole thread Raw
In response to vacuum process is hanging  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
On Wed, Jun 9, 2010 at 12:13 PM, Lonni J Friedman <netllama@gmail.com> wrote:
> hat I'm running is "vacuumdb -v -z -f -d inventory".  I also tried
> removing the -z and -f options to see if that would at least get it to
> complete, but that had no impact.  Here's the tail end of the output,
> leading up to the hang:

Check the pg_stat_activity view for any processes waiting on locks, or
in "idle in transaction" state for a long time.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Cognitive dissonance
Next
From: Janning
Date:
Subject: checkpoint spikes