Horton

Re: Query on partitioned table needs memory n_partitions * work_mem

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dimitrios Apostolou <jimis@gmx.net>
Cc: David Rowley <dgrowleyml@gmail.com>, pgsql-general@lists.postgresql.org
Date: 2024-07-11T14:43:42Z
Lists: pgsql-general 
Dimitrios Apostolou <jimis@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

Commits

  1. Doc: mention executor memory usage for enable_partitionwise* GUCs