Re: Short-living Memory Context in the optimiser

On 12/25/24 12:30, Michael Paquier wrote: On Wed, Dec 25, 2024 at 11:56:24AM +0700, Andrei Lepikhov wrote: Here is a rebased and slightly commented Tom's patch separated from the discussion [1]. Seems to me that there is no patch? -- Michael Pardon me, patch attached. -- regards, Andrei Lepi

Re: Short-living Memory Context in the optimiser

On Wed, Dec 25, 2024 at 11:56:24AM +0700, Andrei Lepikhov wrote: > Here is a rebased and slightly commented Tom's patch separated from the > discussion [1]. Seems to me that there is no patch? -- Michael signature.asc Description: PGP signature

Short-living Memory Context in the optimiser

Hi, Here is a rebased and slightly commented Tom's patch separated from the discussion [1]. I still occasionally see that planner peak memory consumption is triggered by selectivity estimation of massive arrays and clauses generated for multiple partitions. I think that in case of a growing