Re: performance degredation after upgrade from 9.6 to 12

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: Andrew Zakharov <Andrew898(at)mail(dot)ru>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: performance degredation after upgrade from 9.6 to 12
Date: 2019-12-16 17:29:12
Message-ID: CAFj8pRCr_Uvm9f5DUsnu=gxtB1Pf7n4xt1jgdRgUoGzPVsJMqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

po 16. 12. 2019 v 14:02 odesílatel Mariel Cherkassky <
mariel(dot)cherkassky(at)gmail(dot)com> napsal:

> I see, thank u !
> Maybe I didnt see big difference because most of my tables arent so big.
> My db`s size is 17GB and the largest table contains about 20M+ records.
>

Postgres 12 has enabled JIT by default.

Pavel

> Thanks again !
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pratmeht 2019-12-17 05:00:01 DDLs of a Function
Previous Message Mariel Cherkassky 2019-12-16 13:01:57 Re: performance degredation after upgrade from 9.6 to 12

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Geoghegan 2019-12-16 20:39:10 Re: Consecutive Query Executions with Increasing Execution Time
Previous Message Shijia Wei 2019-12-16 17:28:09 Re: Consecutive Query Executions with Increasing Execution Time