Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3 - Mailing list pgsql-admin

From Jason Culverhouse
Subject Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3
Date
Msg-id 73FACE25-A114-4F01-857C-F21067ADA1BA@Mischievous.org
Whole thread Raw
Responses Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
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>'orderby 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



pgsql-admin by date:

Previous
From: Enrico Weigelt
Date:
Subject: dump diffs even w/o db changes
Next
From: Tom Lane
Date:
Subject: Re: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3