Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge memory consumption on partitioned table with FKs - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Huge memory consumption on partitioned table with FKs
Date
Msg-id CANP8+jJam6AVLg7tojD0cBDPP3PANXokhpUopM2+wqbDWpjeyQ@mail.gmail.com
Whole thread Raw
In response to Re: Huge memory consumption on partitioned table with FKs  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: legrand legrand
Date:
Subject: Re: pg_stat_statements oddity with track = all
Next
From: Muhammad Usama
Date:
Subject: Re: A new function to wait for the backend exit after termination