Re: [HACKERS] Dropping a partitioned table takes too long

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Dropping a partitioned table takes too long
Дата
Msg-id CA+TgmoZVvVyMDKEc__2gr+3A0-oMEo-FhDbQLoS-twMvq9_PUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Dropping a partitioned table takes too long  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: [HACKERS] Dropping a partitioned table takes too long
Re: [HACKERS] Dropping a partitioned table takes too long
Список pgsql-hackers
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: [HACKERS] [BUGS] ON CONFLICT with constraint name doesn't work
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables