Search Postgresql Archives

Re: Query on partitioned table needs memory n_partitions * work_mem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Query on partitioned table needs memory n_partitions * work_mem
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 11 Jul 2024 10:43:42 -0400
Cc: David Rowley <dgrowleyml@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx
Comments: In-reply-to Dimitrios Apostolou <jimis@xxxxxxx> message dated "Thu, 11 Jul 2024 16:08:42 +0200"
In-reply-to: <d26e67d3-74bc-60aa-bf24-2a8fb83efe9c@gmx.net>
References: <3603c380-d094-136e-e333-610914fb3e80@gmx.net> <CAApHDvp_u6SbyTKtk9m7ssh8H4dXMoLMZrAq8a1sJk1cj6YxzQ@mail.gmail.com> <d26e67d3-74bc-60aa-bf24-2a8fb83efe9c@gmx.net>

Dimitrios Apostolou <jimis@xxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Query on partitioned table needs memory n_partitions * work_mem
  - From: Dimitrios Apostolou

References:
- Query on partitioned table needs memory n_partitions * work_mem
  - From: Dimitrios Apostolou
- Re: Query on partitioned table needs memory n_partitions * work_mem
  - From: David Rowley
- Re: Query on partitioned table needs memory n_partitions * work_mem
  - From: Dimitrios Apostolou

Prev by Date: Re: Query on partitioned table needs memory n_partitions * work_mem
Next by Date: Running psql in a docker container
Previous by thread: Re: Query on partitioned table needs memory n_partitions * work_mem
Next by thread: Re: Query on partitioned table needs memory n_partitions * work_mem
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux