PL/pgSQL and shared_preload_libraries

Started by Bruce Momjianover 15 years ago2 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Since we now install PL/pgSQL by default, should we configure
shared_preload_libraries to preload PL/pgSQL?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#1)
Re: PL/pgSQL and shared_preload_libraries

Bruce Momjian <bruce@momjian.us> writes:

Since we now install PL/pgSQL by default, should we configure
shared_preload_libraries to preload PL/pgSQL?

I don't think that follows. The fact that it's there doesn't mean
everyone is using it. In any case, I've seen no evidence that says
you'd get a performance win this way. The preload feature is meant
for modules that do a substantial amount of work at load time, which
plpgsql does not.

regards, tom lane