Re: SQLFunctionCache and generic plans - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: SQLFunctionCache and generic plans
Date
Msg-id CAFj8pRCz4NRas1KNWnE5=8Lg16MNOYPb9OAU3SzDrS+WBy3BBQ@mail.gmail.com
Whole thread Raw
In response to Re: SQLFunctionCache and generic plans  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: AIO v2.5
Next
From: Gurjeet Singh
Date:
Subject: Re: Thinko in pgstat_build_snapshot()