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

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

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






--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com



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

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