Thanks Michael. I will check this further.
On Tue, Oct 19, 2021 at 7:09 PM Michael Lewis <mlewis@xxxxxxxxxxx> 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.
