On Wed, Jun 9, 2010 at 12:13 PM, Lonni J Friedman <netllama(at)gmail(dot)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.