Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64

Поиск
Список
Период
Сортировка
От Rick Otten
Тема Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64
Дата
Msg-id CAMAYy4JF+8=dWmmZAubKvJE9f9oMAYKPd9rOVUwhWDn2uvFM0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64  (Mladen Gogala <gogala.mladen@gmail.com>)
Список pgsql-performance


On Mon, Nov 15, 2021 at 8:57 AM Mladen Gogala <gogala.mladen@gmail.com> wrote:


On 11/15/21 00:04, Pavel Stehule wrote:

Hi


There is a CentOS8-stream version which solves the problem but I cannot
use that in the office. I will probably have to wait for another month
before OL8 has everything that I need in its repositories. Now, the
question is what kind of an impact will running without llvm-jit have?
According to the links below, llvm-jit effects are quite spectacular:

https://llvm.org/devmtg/2016-09/slides/Melnik-PostgreSQLLLVM.pdf

https://www.pgcon.org/2017/schedule/events/1092.en.html

When JIT was used on very large query with a lot of CASE expr, then JIT has a positive effect about 50%. On usual large queries, the effect of JIT was about 20%. Unfortunately, JIT is sensitive to estimation, and the JIT sometimes increases seconds to queries, although without JIT this query is executed in ms. When you use a query that can be well calculated in parallel, then positive effect of JIT is less.

Regards

Pavel

Thanks Pavel, you answered my question. I'll wait with the upgrade.



FWIW, there was a lively discussion on the postgresql subreddit over the weekend on JIT:  https://www.reddit.com/r/PostgreSQL/comments/qtsif5/cascade_of_doom_jit_and_how_a_postgres_update_led/
 
(lively for that subreddit anyway)
 

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Lock contention high