Re: SQLFunctionCache and generic plans

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: SQLFunctionCache and generic plans
Дата
Msg-id CAFj8pRCz4NRas1KNWnE5=8Lg16MNOYPb9OAU3SzDrS+WBy3BBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQLFunctionCache and generic plans  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi
 
We get substantial wins on all of fx, fx3, fx4.  fx2 is the
case that gets inlined and never reaches functions.c, so the
lack of change there is expected.  What I found odd is that
I saw a small speedup (~6%) on fx5 and fx6; those functions
are in plpgsql so they really shouldn't change either.
The only thing I can think of is that I made the hash key
computation a tiny bit faster by omitting unused argtypes[]
entries.  That does avoid hashing several hundred bytes
typically, but it's hard to believe it'd amount to any
visible savings overall.

Anyway, PFA v10.


I can confirm so all tests passed without problems

Regards

Pavel
 
                        regards, tom lane

[1] https://www.postgresql.org/message-id/CAFj8pRDWDeF2cC%2BpCjLHJno7KnK5kdtjYN-f933RHS7UneArFw%40mail.gmail.com

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