Re: VACUUM is hanging

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM is hanging
Дата
Msg-id 25155.988988993@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Ответы Re: VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Re: VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Список 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 по дате отправления:

Предыдущее
От: "Gordan Bobic"
Дата:
Сообщение: Re: Ideal hardware configuration for pgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Another "why am I not using the indicies?"