Re: plpgsql function startup-time improvements

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: plpgsql function startup-time improvements
Дата
Msg-id CAFj8pRAnfEkoJYUnUD_ZNpnDSV8tdLpQk-0rT5_5Z-Q0ZqH7kQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpgsql function startup-time improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: CONSTANT/NOT NULL/initializer properties for plpgsql record variables
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Possible performance regression with pg_dump of a large numberof relations