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