Re: Creating foreign key on partitioned table is too slow

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Creating foreign key on partitioned table is too slow
Дата
Msg-id 20191113200011.GA13341@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Creating foreign key on partitioned table is too slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Creating foreign key on partitioned table is too slow
Список pgsql-hackers
On 2019-Nov-13, Tom Lane wrote:

> (BTW, a different question one could ask is exactly why
> RelationBuildPartitionDesc is so profligate of leaked memory.)

The original partitioning code (f0e44751d717) decided that it didn't
want to bother with adding a "free" routine for PartitionBoundInfo
structs, maybe because it had too many pointers, so there's no way for
RelationBuildPartitionDesc to free everything it allocates anyway.  We
could add a couple of pfrees and list_frees here and there, but for the
main thing being leaked we'd need to improve that API.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Invisible PROMPT2
Следующее
От: Andres Freund
Дата:
Сообщение: Re: JIT performance bug/regression & JIT EXPLAIN