Обсуждение: The first function call
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.
Diego Silva e Silva <diegogrv@gmail.com> writes:
> 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.
The first few operations in a new session are necessarily going to be
slower than later ones, because of the need to populate internal caches
etc. If your function is written in a PL you might be able to shave
some time off by preloading the PL's shared library (see
shared_preload_libraries), but that will only go so far. The real
solution to this class of complaints is generally "use a connection
pooler".
regards, tom lane
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.
You would need to provide considerably more detail about the function to receive any useful suggestions - there is no magic switch that you can throw to gain the benefits of caching. Session pooling is usually the first solution to at least minimize how often the cache goes away.
David J.
P.S. This is not an on-topic question for the -hackers list, -general is a better location.