On Wed, Jun 9, 2010 at 10:13 AM, Lonni J Friedman <netllama@xxxxxxxxx> 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. It normally finishes in under 5 minutes. There are no > errors in the output, it just stops producing any output. The command > that 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: Well, -f isn't highly recommended anyway, and if you have to do it you probably need to schedule a reindex to run after it. Anyway, what does top say about the pg process running the vacuum? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
