Re: [HACKERS] JIT compiling - v4.0

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: [HACKERS] JIT compiling - v4.0
Дата
Msg-id CAKJS1f-qGS+as2fMZwkdP1tj6hfUnXmFv0T_MKWPenGdd5UyEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] JIT compiling - v4.0  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] JIT compiling - v4.0  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 5 October 2017 at 19:57, Andres Freund <andres@anarazel.de> wrote:
> Here's some numbers for a a TPC-H scale 5 run. Obviously the Q01 numbers
> are pretty nice in partcular. But it's also visible that the shorter
> query can loose, which is largely due to the JIT overhead - that can be
> ameliorated to some degree, but JITing obviously isn't always going to
> be a win.

It's pretty exciting to see thing being worked on.

I've not looked at the code, but I'm thinking, could you not just JIT
if the total cost of the plan is estimated to be > X ? Where X is some
JIT threshold GUC.


-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Amit Khandekar
Дата:
Сообщение: Re: [HACKERS] Parallel Append implementation
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Another oddity in handling of WCO constraints inpostgres_fdw