| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Andrew Zakharov <Andrew898(at)mail(dot)ru>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: performance degredation after upgrade from 9.6 to 12 |
| Date: | 2019-12-16 11:48:20 |
| Message-ID: | CA+t6e1mL38NgvE-_AZoXH4DzG9bJNO6zvoQhy=5M0pN_qBJ6JA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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..
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Zakharov | 2019-12-16 12:27:01 | RE: performance degredation after upgrade from 9.6 to 12 |
| Previous Message | Min Wang | 2019-12-12 21:18:55 | RE: PostgreSQL 11 sends shared secret to RADIUS server in all low case |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Zakharov | 2019-12-16 12:27:01 | RE: performance degredation after upgrade from 9.6 to 12 |
| Previous Message | Olivier Gautherot | 2019-12-16 10:17:50 | Re: Consecutive Query Executions with Increasing Execution Time |