From: | David Rowley <drowley(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC |
Date: | 2024-07-31 13:26:05 |
Message-ID: | E1sZ9LB-0022Gi-U0@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Doc: mention executor memory usage for enable_partitionwise* GUCs
Prior to this commit, the docs for enable_partitionwise_aggregate and
enable_partitionwise_join mentioned the additional overheads enabling
these causes for the query planner, but they mentioned nothing about the
possible surge in work_mem-consuming executor nodes that could end up in
the final plan. Dimitrios reported the OOM killer intervened on his
query as a result of using enable_partitionwise_aggregate=on.
Here we adjust the docs to mention the possible increase in the number of
work_mem-consuming executor nodes that can appear in the final plan as a
result of enabling these GUCs.
Reported-by: Dimitrios Apostolou
Reviewed-by: Ashutosh Bapat
Discussion: https://postgr.es/m/3603c380-d094-136e-e333-610914fb3e80%40gmx.net
Discussion: https://postgr.es/m/CAApHDvoZ0_yqwPFEpb6h261L76BUpmh5GxBQq0LeRzQ5Jh3zzg@mail.gmail.com
Backpatch-through: 12, oldest supported version
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/057ee9183c2142f6ecd9035aa6b96c5509c18a27
Modified Files
--------------
doc/src/sgml/config.sgml | 20 ++++++++++++++------
1 file changed, 14 insertions(+), 6 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2024-07-31 13:26:45 | pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC |
Previous Message | Peter Eisentraut | 2024-07-31 09:18:15 | pgsql: Add API and ABI stability guidance to the C language docs |