Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: Big performance slowdown from 11.2 to 13.3
Date
Msg-id CAApHDvqoF7y7SQjGT=940njnAd_CUcUG6oRYChcP_+eJyuNiug@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>)
Responses RE: Big performance slowdown from 11.2 to 13.3
List pgsql-performance
Tree view 
On Thu, 22 Jul 2021 at 16:37, ldh@laurent-hasson.com
<ldh@laurent-hasson.com> wrote:
> Seems like no cigar ☹ See plan pasted below. I changed the conf as follows:
>   - hash_mem_multiplier = '2'
>   - work_mem = '1GB'

>         Batches: 5  Memory Usage: 2400305kB  Disk Usage: 126560kB

You might want to keep going higher with hash_mem_multiplier until you
see no "Disk Usage" there.  As mentioned, v11 didn't spill to disk and
just used all the memory it pleased.  That was a bit dangerous as it
could result in OOM, so it was fixed.

David

pgsql-performance by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big performance slowdown from 11.2 to 13.3
Next
From: Kamil Frydel
Date:
Subject: Partitioned table statistics vs autoanalyze