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 по дате отправления: