Re: loading libraries on Postmaster startup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: loading libraries on Postmaster startup
Date: 2003-02-13 04:55:14
Message-ID: 10471.1045112114@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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.

(I seem to recall Peter muttering about linking plperl, pltcl, etc
statically into the backend; which would reduce the need for this.
But it would not eliminate it ... and he hasn't done it anyway...)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-02-13 05:06:32 Re: targetlist functions part 1 (was [HACKERS] targetlist
Previous Message Bruce Momjian 2003-02-13 04:47:39 Re: psql source suggestions

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-02-13 05:06:32 Re: targetlist functions part 1 (was [HACKERS] targetlist
Previous Message Bruce Momjian 2003-02-13 04:54:19 Re: pg_dump a specific schema