public inbox for [email protected]
help / color / mirror / Atom feedFrom: Олександр Янін <[email protected]>
To: Johnathan Tiamoh <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
Date: Mon, 22 Apr 2024 22:01:17 +0300
Message-ID: <CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@mail.gmail.com> (raw)
In-Reply-To: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
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.
ср, 17 апр. 2024 г. в 20:13, Johnathan Tiamoh <[email protected]>:
> Hello,
>
>
> I performed an upgrade from postgresql-9.5 to postgresql-14 and the
> performance has degraded drastically.
>
> Please, is they any advice on getting performance back ?
>
>
> King Regards
> Johnathan T.
>
>
>
>
--
Цей електронний лист та будь-які передані разом із ним файли є
кoнфіденцiйною iнформацiєю, що належить ПриватБанку й призначена тільки для
використання фізичною або юридичною особою, якій їх адресовано. Якщо ви не
зазначений адресат, то не маєте права зберігати, поширювати або копіювати
цей лист. У разі помилкового отримання просимо видалити його та повідомити
автору.
This email and any files transmitted with it are confidential
information belonging to PrivatBank and intended solely for the use of the
individual or entity to whom they are addressed. If you are not the named
addressее, you are not authorised to further store, disseminate or copy it.
In case of receiving this email by mistake we kindly ask to delete it and
inform the author.
view thread (9+ messages) latest in thread
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]
Subject: Re: Performance degradation after upgrading from 9.5 to 14
In-Reply-To: <CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@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