From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] loading libraries on Postmaster startup |
Date: | 2003-02-22 19:09:34 |
Message-ID: | 3E57CAEE.8070509@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Joe Conway <mail(at)joeconway(dot)com> writes:
>>[ what about autoloading libraries into the postmaster? ]
>
> I can see a couple possible downsides: (a) the library might have some
> weird behavior across fork boundaries; (b) the additional memory space
> that has to be duplicated into child processes will cost something per
> child launch, even if the child never uses it. But these are only
> arguments that it might not *always* be a prudent thing to do, not that
> we shouldn't give the DBA the tool to do it if he wants. So fire away.
Here is a patch for the above, including a documentation update. It
creates a new GUC variable "preload_libraries", that accepts a list in
the form:
preload_libraries = '$libdir/mylib1:initfunc,$libdir/mylib2'
If ":initfunc" is omitted or not found, no initialization function is
executed, but the library is still preloaded. If "$libdir/mylib" isn't
found, the postmaster refuses to start.
In my testing with PL/R, it reduces the first call to a PL/R function
(after connecting) from almost 2 seconds, down to about 8 ms.
If there are no objections, please apply.
Thanks,
Joe
Attachment | Content-Type | Size |
---|---|---|
preload-libs.1.patch | text/plain | 7.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-22 19:22:03 | Re: [HACKERS] loading libraries on Postmaster startup |
Previous Message | Vince Vielhaber | 2003-02-22 15:57:14 | Re: ILIKE |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-22 19:22:03 | Re: [HACKERS] loading libraries on Postmaster startup |
Previous Message | Tom Lane | 2003-02-22 16:54:42 | Re: pg_ctl -w port detection |