Search Postgresql Archives

Re: vacuum process is hanging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux