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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Dropping a partitioned table takes too long
Дата
Msg-id CA+TgmoY98qeG1rpHD3ccoawerYWuRp6A8NPPPMHqT9Tcyevusg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Dropping a partitioned table takes too long  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Crash when partition column specified twice
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Dropping a partitioned table takes too long