Re: VACUUM is hanging

Ashley Clark <aclark@ghoti.org> writes:
> * Tom Lane in "Re: [GENERAL] VACUUM is hanging" dated 2001/05/04 11:09
> * wrote:
>> 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.

> I would agree except that this is a product in testing and there should
> be NOTHING accessing it at 4am.

The postmaster will be firing off periodic checkpoint subprocesses even
if there's no user activity.  That's probably what those are.

>> It's unclear what the process doing the vacuum could be waiting for;
>> can you attach to it with gdb and get a backtrace?

> I'll try to recreate the situation and get a backtrace, if that's
> successful I guess I'll have to recompile with -g to get really useful
> information.

The backtrace might be useful even if it just shows routine names...

            regards, tom lane