Re: performance degredation after upgrade from 9.6 to 12 - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: performance degredation after upgrade from 9.6 to 12
Date
Msg-id CA+t6e1mL38NgvE-_AZoXH4DzG9bJNO6zvoQhy=5M0pN_qBJ6JA@mail.gmail.com
Whole thread Raw
In response to Re: performance degredation after upgrade from 9.6 to 12  (Jeff Janes <jeff.janes@gmail.com>)
Responses RE: performance degredation after upgrade from 9.6 to 12  ("Andrew Zakharov" <Andrew898@mail.ru>)
List 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 by date:

Previous
From: Olivier Gautherot
Date:
Subject: Re: Consecutive Query Executions with Increasing Execution Time
Next
From: "Andrew Zakharov"
Date:
Subject: RE: performance degredation after upgrade from 9.6 to 12