Add mention of execution time memory for enable_partitionwise_* GUCs

Поиск
Список
Период
Сортировка
От David Rowley
Тема Add mention of execution time memory for enable_partitionwise_* GUCs
Дата
Msg-id CAApHDvoZ0_yqwPFEpb6h261L76BUpmh5GxBQq0LeRzQ5Jh3zzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Add mention of execution time memory for enable_partitionwise_* GUCs
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Built-in CTYPE provider
Следующее
От: David Zhang
Дата:
Сообщение: Re: Proposal for implementing OCSP Stapling in PostgreSQL