Re: Query on partitioned table needs memory n_partitions * work_mem

[Tom Lane]

Dimitrios Apostolou <ji...@gmx.net> writes:
> The TABLE test_runs_raw has 1000 partitions on RANGE(workitem_n).

So don't do that.  Adding partitions is not cost-free.

                        regards, tom lane