Postgres Pro
Downloads
Home   >   mailing lists

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+TgmoZVvVyMDKEc__2gr+3A0-oMEo-FhDbQLoS-twMvq9_PUw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Dropping a partitioned table takes too long  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: [HACKERS] Dropping a partitioned table takes too long  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Re: [HACKERS] Dropping a partitioned table takes too long  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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.

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

pgsql-hackers by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: Re: [HACKERS] [BUGS] ON CONFLICT with constraint name doesn't work
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables