Re: Big performance slowdown from 11.2 to 13.3

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Big performance slowdown from 11.2 to 13.3
Дата
Msg-id CAKFQuwakkn=FDRpEaUa4EXHrhHpKAFWn1fv9CRes0VfpxFTMrw@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Big performance slowdown from 11.2 to 13.3  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список pgsql-performance
Дерево обсуждения
On Tue, Jul 27, 2021 at 7:57 PM ldh@laurent-hasson.com <ldh@laurent-hasson.com> wrote:
hash_mem_multiplier is an upper-bound right: it doesn't reserve memory ahead of time correct?

Yes, that is what the phrasing "maximum amount" in the docs is trying to convey.

https://www.postgresql.org/docs/current/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY

But also note that it is "each operation" that gets access to that limit.

David J.

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

Предыдущее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: RE: Big performance slowdown from 11.2 to 13.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Big performance slowdown from 11.2 to 13.3