Home > mailing lists

The first function call - Mailing list pgsql-hackers

From	Diego Silva e Silva
Subject	The first function call
Date	January 11, 2018 21:52:10
Msg-id	CADecqhHWSkuGGaKCeHQ2V4Bz==cVgcXATLTERspMx1-nPE1yXQ@mail.gmail.com Whole thread Raw
Responses	Re: The first function call Re: The first function call
List	pgsql-hackers

Hello,

The first function call is 10 times slower than the other calls in the same session. Is it possible to shorten this long time on the first call?

For example. Call my function for once, this call returns at 70ms on the next call, the return is at 7ms.

thanks.

From: Tom Lane
Date: 11 January 2018, 21:42:38
Subject: Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs

From: Ildar Musin
Date: 11 January 2018, 21:53:22
Subject: Re: General purpose hashing func in pgbench