Re: Huge memory consumption on partitioned table with FKs

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Huge memory consumption on partitioned table with FKs
Дата
Msg-id CANP8+jJam6AVLg7tojD0cBDPP3PANXokhpUopM2+wqbDWpjeyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Huge memory consumption on partitioned table with FKs  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
On Tue, 1 Dec 2020 at 00:03, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> cache entry is reused in the common case where they are identical.

Does a similar situation exist for partition statistics accessed
during planning? Or planning itself?

It would be useful to avoid repeated access to similar statistics and
repeated planning of sub-plans for similar partitions.

-- 
Simon Riggs                http://www.EnterpriseDB.com/



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