Home > mailing lists

Re: Big performance slowdown from 11.2 to 13.3 - Mailing list pgsql-performance

From	David G. Johnston
Subject	Re: Big performance slowdown from 11.2 to 13.3
Date	July 28, 2021 06:06:59
Msg-id	CAKFQuwakkn=FDRpEaUa4EXHrhHpKAFWn1fv9CRes0VfpxFTMrw@mail.gmail.com Whole thread Raw
In response to	RE: Big performance slowdown from 11.2 to 13.3 ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
List	pgsql-performance

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.

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

David J.

From: "ldh@laurent-hasson.com"
Date: 28 July 2021, 05:57:48
Subject: RE: Big performance slowdown from 11.2 to 13.3

From: Tom Lane
Date: 28 July 2021, 06:15:52
Subject: Re: Big performance slowdown from 11.2 to 13.3