any issue with enable_partitionwise_join at instance level?

From: Ayub M <hiayub(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: any issue with enable_partitionwise_join at instance level?
Date: 2020-10-11 18:45:29
Message-ID: CAOS0qEtv+VR9Fse3sRs4_qSL7cRtcA4ZcLhXR7qQe1iiuJuWbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, while running aggregate queries on partitioned table there is
improvement when enable_partitionwise_join is turned on. By default this
parameter is disabled and going by the documentation it says (
https://www.postgresql.org/docs/11/runtime-config-query.html)

```
Because partitionwise grouping or aggregation can use significantly more
CPU time and memory during planning, the default is off.
```

Why would it take "significantly" more CPU and memory for the planner? Is
there any foreseeable issues when enabling this at the instance level?

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2020-10-12 00:16:54 Re: rum index supported on pg13?
Previous Message Jony Cohen 2020-10-11 06:45:48 Re: Gurjeet Singh Index Adviser User Interface