Shrirang Chitnis <shrirang.chit...@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 that I 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
