Postgres Pro
Downloads
Home   >   mailing lists

Re: Query on partitioned table needs memory n_partitions * work_mem - Mailing list pgsql-general

From Tom Lane
Subject Re: Query on partitioned table needs memory n_partitions * work_mem
Date
Msg-id 2077940.1720709022@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query on partitioned table needs memory n_partitions * work_mem  (Dimitrios Apostolou <jimis@gmx.net>)
Responses Re: Query on partitioned table needs memory n_partitions * work_mem
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: Query on partitioned table needs memory n_partitions * work_mem
Next
From: H
Date:
Subject: Running psql in a docker container