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 по дате отправления:

Предыдущее
От: legrand legrand
Дата:
Сообщение: Re: pg_stat_statements oddity with track = all
Следующее
От: Muhammad Usama
Дата:
Сообщение: Re: A new function to wait for the backend exit after termination