Re: VACUUM is hanging - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM is hanging
Date
Msg-id 25155.988988993@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Responses Re: VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Re: VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Gordan Bobic"
Date:
Subject: Re: Ideal hardware configuration for pgsql
Next
From: Tom Lane
Date:
Subject: Re: Another "why am I not using the indicies?"