Postgres Pro
Downloads
Home   >   mailing lists

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

From bricklen
Subject Re: Fighting the autovacuumer (to prevent wraparound)
Date
Msg-id CAGrpgQ_Sg9t3k7SD+OGdM72C_zLe0Rkh3REExSEJHkoBFPMC3Q@mail.gmail.com
Whole thread Raw
In response to Fighting the autovacuumer (to prevent wraparound)  (Michael Graham <mgraham@bloxx.com>)
Responses Re: Fighting the autovacuumer (to prevent wraparound)  (Michael Graham <mgraham@bloxx.com>)
Re: Fighting the autovacuumer (to prevent wraparound)  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view

On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham <mgraham@bloxx.com> wrote:
Hi all,

We partition the data in postgres in a per-month basis and run a script
to delete old partitions.

Does "delete" = "drop"?
 
 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.

Are you uninheriting the partition before attempting to get rid of it?
Eg.
ALTER TABLE your_partition NO INHERIT the_parent_table;




pgsql-general by date:

Previous
From: Michael Graham
Date:
Subject: Fighting the autovacuumer (to prevent wraparound)
Next
From: Michael Graham
Date:
Subject: Re: Fighting the autovacuumer (to prevent wraparound)