Re: Fun fact about autovacuum and orphan temp tables - Mailing list pgsql-hackers

From Constantin S. Pan
Subject Re: Fun fact about autovacuum and orphan temp tables
Date
Msg-id 20161021130858.620751f1@ppg
Whole thread Raw
In response to Re: Fun fact about autovacuum and orphan temp tables  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On Fri, 21 Oct 2016 14:29:24 +0900
Michael Paquier <michael.paquier@gmail.com> wrote:

> That's invasive. I am wondering if a cleaner approach here would be a
> flag in deleteOneObject() that performs the lock cleanup, as that's
> what you are trying to solve here.

The problem occurs earlier, at the findDependentObjects step. All the
objects inside the namespace are being locked before any of them gets
deleted, which leads to the "too many locks" condition.

Cheers,
Constantin Pan



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Question about behavior of snapshot too old feature
Next
From: Amit Kapila
Date:
Subject: Re: Parallel tuplesort (for parallel B-Tree index creation)