Re: VACUUM is hanging

Ashley Clark <aclark@ghoti.org> writes:
> 2001-05-04 04:00:09 [27285]  DEBUG:  Analyzing...
> /usr/lib/postgresql/bin/postmaster: reaping dead processes...
> /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 27299 exited with stat=
> us 0
> /usr/lib/postgresql/bin/postmaster: reaping dead processes...

Since the PID mentioned by the postmaster is NOT the same one running
the vacuum, presumably this is just an indication that some other
backend finished its work and exited normally.  It's unclear what the
process doing the vacuum could be waiting for; can you attach to it
with gdb and get a backtrace?

            regards, tom lane