On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham <mgraham(at)bloxx(dot)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;