Re: Performance degradation after upgrading from 9.5 to 14 - Mailing list pgsql-general

From David Rowley
Subject Re: Performance degradation after upgrading from 9.5 to 14
Date
Msg-id CAApHDvqJK+ARTYLYeS-C1i_seVbcp0nfCVbxu960nGpssFJA+w@mail.gmail.com
Whole thread Raw
In response to Re: Performance degradation after upgrading from 9.5 to 14  (Олександр Янін <aleksandr.janin@privatbank.ua>)
List pgsql-general
On Tue, 23 Apr 2024 at 07:01, Олександр Янін
<aleksandr.janin@privatbank.ua> wrote:
> Try setting enable_memoize to off.
> Our practice has shown that enabling this parameter by default often resulted in less than optimal query plans in the
cache.

It would be good to see a thread opened with details on this.  I
understand incorrect statistics can cause this but if there are other
reasons, it would be good to know what they are.

David



pgsql-general by date:

Previous
From: Atul Kumar
Date:
Subject: Re: issue with reading hostname
Next
From: Ron Johnson
Date:
Subject: Re: issue with reading hostname