pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC - Mailing list pgsql-committers

From David Rowley
Subject pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC
Date
Msg-id E1sZ9Nh-0022Lt-4o@gemulon.postgresql.org
Whole thread Raw
List 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
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5eea78af2d3c0f78b97bcaa036bccd9b28b96592

Modified Files
--------------
doc/src/sgml/config.sgml | 20 ++++++++++++++------
1 file changed, 14 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC
Next
From: David Rowley
Date:
Subject: pgsql: Doc: mention executor memory usage for enable_partitionwise* GUC