Shrirang Chitnis <Shrirang.Chitnis@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
