PostgreSQL是否持续加载其pl *解释器？ [英] Does PostgreSQL keep its pl* interpreters loaded persistently?

问题描述

如果我在plperlu中写过什么，什么时候可以重新加载该模块？每次运行该功能？第一次运行？如果一段时间未使用Perl DLL，它是否会被卸载，然后再重新加载另一个模块？

If I wrote something in plperlu, when would that module be reloaded? Every time the function ran? The first time it ran? Does the Perl DLL get unloaded if it hasn't been used in a while, and then after that it'd be another module reload?

推荐答案

我认为在该会话中首次使用该语言时，该模块将为每个服务器进程（即新会话/连接）加载一次。

I think the module will be loaded once for each server process (i.e. new session / connection) on the first use of that language within that session.

您可以预先加载它们，以避免首次使用时出现任何延迟，每
shared_preload_libraries 和 local_preload_libraries 。

You can preload them to avoid any delay on first use, per the manual for shared_preload_libraries and local_preload_libraries.

旧的PostgreSQL版本只有一个 preload_libraries 设置；如果您使用的是旧版本，请参见您所用版本的手册。

Old PostgreSQL versions just had a single preload_libraries setting; see the manual for your version if you're on something very old.

这篇关于PostgreSQL是否持续加载其pl *解释器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！