public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Rowley <[email protected]>
To: Олександр Янін <[email protected]>
Cc: Johnathan Tiamoh <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
Date: Tue, 23 Apr 2024 09:43:47 +1200
Message-ID: <CAApHDvqJK+ARTYLYeS-C1i_seVbcp0nfCVbxu960nGpssFJA+w@mail.gmail.com> (raw)
In-Reply-To: <CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@mail.gmail.com>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
<CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@mail.gmail.com>
On Tue, 23 Apr 2024 at 07:01, Олександр Янін
<[email protected]> 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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Performance degradation after upgrading from 9.5 to 14
In-Reply-To: <CAApHDvqJK+ARTYLYeS-C1i_seVbcp0nfCVbxu960nGpssFJA+w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox