Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Dropping a partitioned table takes too long - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Dropping a partitioned table takes too long
Date
Msg-id 8cf3a21c-78ff-e950-0720-a1f53d1d01ef@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Dropping a partitioned table takes too long  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Dropping a partitioned table takes too long
List pgsql-hackers
Tree view 
On 4/26/17 12:15, Robert Haas wrote:
> On Tue, Apr 25, 2017 at 10:05 PM, Amit Langote
> <Langote_Amit_f8@lab.ntt.co.jp> wrote:
>>> The attached patch try to replace 'heap_open' with 'LockRelationOid' when
>>> locking parent table.
>>> It improved dropping a table with 7000 partitions.
>>
>> Your patch seems to be a much better solution to the problem, thanks.
> 
> Does anyone wish to object to this patch as untimely?
> 
> If not, I'll commit it.

Seems quite reasonable.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Dropping a partitioned table takes too long