Postgres Pro
Downloads
Home   >   mailing lists

Fighting the autovacuumer (to prevent wraparound) - Mailing list pgsql-general

From Michael Graham
Subject Fighting the autovacuumer (to prevent wraparound)
Date
Msg-id 1380826091.16581.77.camel@smokey
Whole thread Raw
Responses Re: Fighting the autovacuumer (to prevent wraparound)  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view 
Hi all,

We partition the data in postgres in a per-month basis and run a script
to delete old partitions.  Sometimes this script fails and the delete
doesn't happen because of a deadlock, today I noticed that it was the
autovacuumer that fighting with the script.

Is it possible to stop the autovacuumer temporarily (and cancel any on
going autovacuum) so that my script can remove the table that the
autovacuumer wants to vacuum?

I'm on 9.1.4 if it matter.

Cheers,
--
Michael Graham <mgraham@bloxx.com>

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: Postgres replication question :- One master 2 slaves 9.0.10
Next
From: bricklen
Date:
Subject: Re: Fighting the autovacuumer (to prevent wraparound)