Thanks Michael. I will check this further. On Tue, Oct 19, 2021 at 7:09 PM Michael Lewis <mle...@entrata.com> wrote:
> Check explain plan, change work mem to 100MBs and then check explain plan > again. If it changed, then try explain analyze. > > Work mem is limit is used per node in the plan, so especially with > partitioned tables, that limit is way too high. >
