Re: VACUUM is hanging

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashley Clark <aclark(at)ghoti(dot)org>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM is hanging
Date: 2001-05-04 15:09:53
Message-ID: 25155.988988993@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ashley Clark <aclark(at)ghoti(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashley Clark 2001-05-04 15:16:23 Re: VACUUM is hanging
Previous Message Gordan Bobic 2001-05-04 15:04:56 Re: Re: Ideal hardware configuration for pgsql