Add mention of execution time memory for enable_partitionwise_* GUCs - Mailing list pgsql-hackers

From David Rowley
Subject Add mention of execution time memory for enable_partitionwise_* GUCs
Date
Msg-id CAApHDvoZ0_yqwPFEpb6h261L76BUpmh5GxBQq0LeRzQ5Jh3zzg@mail.gmail.com
Whole thread Raw
Responses Re: Add mention of execution time memory for enable_partitionwise_* GUCs
List pgsql-hackers
Over on [1], there's a complaint about a query OOMing because the use
of enable_partitionwise_aggregate caused a plan with 1000 Hash
Aggregate nodes.

The only mention in the docs is the additional memory requirements and
CPU for query planning when that GUC is enabled. There's no mention
that execution could use work_mem * nparts more memory to be used.  I
think that's bad and we should fix it.

I've attached my proposal to fix that.

David

[1] https://postgr.es/m/3603c380-d094-136e-e333-610914fb3e80%40gmx.net

Attachment

pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Built-in CTYPE provider
Next
From: David Zhang
Date:
Subject: Re: Proposal for implementing OCSP Stapling in PostgreSQL