Re: [GENERAL] vacuum process is hanging

2010-06-09 Thread Scott Marlowe
On Wed, Jun 9, 2010 at 10:13 AM, Lonni J Friedman wrote: > Greetings, > I've got an 8.1.10 instance running on Linux-i686.  The system hosts 5 > databases, all of which get vacuumed via a cronjob 3 times a day.  All > of a sudden, the vacuum job for 1 of the databases is hanging > indefinitely.  I

Re: [GENERAL] vacuum process is hanging

2010-06-09 Thread Vick Khera
On Wed, Jun 9, 2010 at 12:13 PM, Lonni J Friedman 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:

Re: [GENERAL] vacuum process is hanging

2010-06-09 Thread Tom Lane
Lonni J Friedman writes: > I've got an 8.1.10 instance running on Linux-i686. The system hosts 5 > databases, all of which get vacuumed via a cronjob 3 times a day. All > of a sudden, the vacuum job for 1 of the databases is hanging > indefinitely. Is it actually blocked, or just busy? (strace

[GENERAL] vacuum process is hanging

2010-06-09 Thread Lonni J Friedman
Greetings, I've got an 8.1.10 instance running on Linux-i686. The system hosts 5 databases, all of which get vacuumed via a cronjob 3 times a day. All of a sudden, the vacuum job for 1 of the databases is hanging indefinitely. It normally finishes in under 5 minutes. There are no errors in the