Re: performance degredation after upgrade from 9.6 to 12

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: performance degredation after upgrade from 9.6 to 12
Дата
Msg-id CA+t6e1mL38NgvE-_AZoXH4DzG9bJNO6zvoQhy=5M0pN_qBJ6JA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: performance degredation after upgrade from 9.6 to 12  (Jeff Janes <jeff.janes@gmail.com>)
Ответы RE: performance degredation after upgrade from 9.6 to 12  ("Andrew Zakharov" <Andrew898@mail.ru>)
Список pgsql-performance
Hey Jeff,Andrew,
I continued testing the 12version vs the 96 version and it seems that there is almost non diff and in some cases pg96 is faster than 12. I compared the content of pg_stat_statements after each test that I have done and it seems that the db time is almost the same and sometimes 96 is faster by 5%.

Any idea why there isnt any improvement even when I enabled the parallel params in 12 ?
I can add a few examples if needed..

В списке pgsql-performance по дате отправления:

Предыдущее
От: Olivier Gautherot
Дата:
Сообщение: Re: Consecutive Query Executions with Increasing Execution Time
Следующее
От: "Andrew Zakharov"
Дата:
Сообщение: RE: performance degredation after upgrade from 9.6 to 12