From: Jason Culverhouse <jason@mischievous.org>
To: pgsql-admin@postgresql.org
Subject: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Date: Thu, 29 Apr 2010 10:55:08 -0700
Message-ID: <C818C803-53BD-4E50-9AA9-D5010643AF80@mischievous.org> (raw)
HI,
I have a vacuum process that has been running on a table for the past 20 days.
The server is postgres 8.3 on ubuntu linux.
Can I safely kill the vacuum with:
select pg_cancel_backend(26433)
Some stats
The table sees ~5million and not more than ~10million updates month
$ ps aux | grep 26433
postgres 26433 0.0 1.5 35468848 2012212 ? Ss Apr08 26:00 postgres: autovacuum worker process foo
foo=# select procpid, now() - query_start, query_start, current_query from pg_stat_activity where current_query != '<IDLE>'order by 1 desc;
procpid | ?column? | query_start | current_query
---------+-------------------------+-------------------------------+---------------------------------------------------------------------------------------------------------------------------------------
26433 | 20 days 20:11:32.386244 | 2010-04-08 14:19:59.298784-07 | autovacuum: VACUUM ANALYZE public.message
Thanks,
Jason
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jason@mischievous.org
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
In-Reply-To: <C818C803-53BD-4E50-9AA9-D5010643AF80@mischievous.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox