Re:

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re:
Дата
Msg-id 7844.1240424329@sss.pgh.pa.us
обсуждение исходный текст
Ответ на  (Shrirang Chitnis <Shrirang.Chitnis@hovservices.com>)
Ответы Logs say update done but not actually done or committed into database ???
Список pgsql-admin
Shrirang Chitnis <Shrirang.Chitnis@hovservices.com> writes:
> I see that an auto vacuum process that has started on April 08 is still continuing till date on a production server
thatI manage. 

> A) Is there a way to know whether the process is still running or is stalled?

strace the process for a few minutes and see if it does anything or just
sits there.  Alternatively, does ps show its runtime is increasing?

> B) Can the process be killed safely without causing issues in the autovacuum daemon?

You could try SIGINT'ing it.  Anything stronger might be risky.

            regards, tom lane

В списке pgsql-admin по дате отправления: