Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql function startup-time improvements - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: plpgsql function startup-time improvements
Date
Msg-id CAFj8pRAnfEkoJYUnUD_ZNpnDSV8tdLpQk-0rT5_5Z-Q0ZqH7kQ@mail.gmail.com
Whole thread Raw
In response to Re: plpgsql function startup-time improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
Hi

2018-01-25 0:16 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> please, can you rebase all three patches necessary for patching?

Done.  These now need to be applied over
https://www.postgresql.org/message-id/833.1516834367@sss.pgh.pa.us

Thank you

I checked it

1. there are no problem with patching
2. all tests passed
3. I can confirm so some best case speedup is about 15-20%. Worst case is hard to test - but these changes should not be slower than current master.
4. faster-plpgsql-datum-setup-2.patch is simple patch with few lines of new code
5. plpgsql-promises-2.patch is little bit more complex, but still it is simple
6. the code is well formatted and well commented
7. there are not new test and code, what is not problem - these patches doesn't add any new feature

I'll mark these patches as ready for commiter

Regards

Pavel

 


                        regards, tom lane


pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: CONSTANT/NOT NULL/initializer properties for plpgsql record variables
Next
From: Stephen Frost
Date:
Subject: Re: Possible performance regression with pg_dump of a large numberof relations