Re: performance degredation after upgrade from 9.6 to 12

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: performance degredation after upgrade from 9.6 to 12
From: Pavel Stehule <pavel.stehule@xxxxxxxxx>
Date: Mon, 16 Dec 2019 18:29:12 +0100
Cc: Andrew Zakharov <Andrew898@xxxxxxx>, Jeff Janes <jeff.janes@xxxxxxxxx>, Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CA+t6e1muZH8mVE5OB3K1+5j7BR814oRzhBoS7xbOvQe5Au53pA@mail.gmail.com>
References: <CA+t6e1n1oO2pJLJqPYtt_hZiQhWakF54D9ifXm4403ij3G9LLw@mail.gmail.com> <D5A97466-572B-44B4-AF62-4ED86C08CBC3@mail.ru> <CA+t6e1knyzgqAaRp2W9PtOy5GDPfjJfzAB30MMNQP9gRAX9T_w@mail.gmail.com> <CAMkU=1xfnGWux2Vx4Nypoz764YC8OxctQtYDXvykiGeMVoZKrg@mail.gmail.com> <CA+t6e1mL38NgvE-_AZoXH4DzG9bJNO6zvoQhy=5M0pN_qBJ6JA@mail.gmail.com> <017001d5b40c$1e083800$5a18a800$@mail.ru> <CA+t6e1muZH8mVE5OB3K1+5j7BR814oRzhBoS7xbOvQe5Au53pA@mail.gmail.com>

po 16. 12. 2019 v 14:02 odesílatel Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> 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 !

References:
- performance degredation after upgrade from 9.6 to 12
  - From: Mariel Cherkassky
- Re: performance degredation after upgrade from 9.6 to 12
  - From: Andrew Zakharov
- Re: performance degredation after upgrade from 9.6 to 12
  - From: Mariel Cherkassky
- Re: performance degredation after upgrade from 9.6 to 12
  - From: Jeff Janes
- Re: performance degredation after upgrade from 9.6 to 12
  - From: Mariel Cherkassky
- RE: performance degredation after upgrade from 9.6 to 12
  - From: Andrew Zakharov
- Re: performance degredation after upgrade from 9.6 to 12
  - From: Mariel Cherkassky

Prev by Date: Re: Consecutive Query Executions with Increasing Execution Time
Next by Date: Re: Consecutive Query Executions with Increasing Execution Time
Previous by thread: Re: performance degredation after upgrade from 9.6 to 12
Next by thread: Re: performance degredation after upgrade from 9.6 to 12
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]