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

From Robert Haas
Subject Re: [HACKERS] Dropping a partitioned table takes too long
Date
Msg-id CA+TgmoY98qeG1rpHD3ccoawerYWuRp6A8NPPPMHqT9Tcyevusg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Dropping a partitioned table takes too long  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On Wed, Apr 26, 2017 at 12:21 PM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> 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.

OK, done.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Crash when partition column specified twice
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Dropping a partitioned table takes too long