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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Dropping a partitioned table takes too long
Дата
Msg-id 8cf3a21c-78ff-e950-0720-a1f53d1d01ef@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Dropping a partitioned table takes too long  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] Dropping a partitioned table takes too long
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Dropping a partitioned table takes too long