Re: Performance degradation after upgrading from 9.5 to 14

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Performance degradation after upgrading from 9.5 to 14
Дата
Msg-id CAApHDvqJK+ARTYLYeS-C1i_seVbcp0nfCVbxu960nGpssFJA+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance degradation after upgrading from 9.5 to 14  (Олександр Янін <aleksandr.janin@privatbank.ua>)
Список 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 по дате отправления:

Предыдущее
От: Atul Kumar
Дата:
Сообщение: Re: issue with reading hostname
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: issue with reading hostname