Re: Query out of memory

[Michael Lewis]

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.