public inbox for [email protected]  
help / color / mirror / Atom feed
From: Tom Lane <[email protected]>
To: Robert Haas <[email protected]>
Cc: Nathan Bossart <[email protected]>
Cc: Julien Rouhaud <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: Michael Paquier <[email protected]>
Cc: Bossart, Nathan <[email protected]>
Cc: Fujii Masao <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Bharath Rupireddy <[email protected]>
Cc: Greg Sabino Mullane <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: make MaxBackends available in _PG_init
Date: Fri, 06 May 2022 10:43:21 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+TgmobYKhUvs0vS_QyyHMpPw0OsyQJqNZWpRCcT1jBVwLxTJg@mail.gmail.com>
References: <20220413183040.GA2116671@nathanxps13>
	<Yle2IBsS1Nnp2WWa@jrouhaud>
	<20220414162215.GB2163833@nathanxps13>
	<CA+TgmoYCK9TKxKT_39S7SVD56rgcffFOozzUso2kxStsmvwZRQ@mail.gmail.com>
	<[email protected]>
	<20220418225244.GA2387491@nathanxps13>
	<[email protected]>
	<20220419001220.GA2389330@nathanxps13>
	<[email protected]>
	<Yl6FmT4qXTA7/NJm@jrouhaud>
	<20220419154658.GA2487941@nathanxps13>
	<CA+TgmobNyQvge4rgFUKpZyz2TZqv=2dt3XpPPu7HQttCm8i2Cw@mail.gmail.com>
	<[email protected]>
	<CA+TgmobYKhUvs0vS_QyyHMpPw0OsyQJqNZWpRCcT1jBVwLxTJg@mail.gmail.com>

Robert Haas <[email protected]> writes:
> On Fri, May 6, 2022 at 9:57 AM Tom Lane <[email protected]> wrote:
>> I agree that _PG_fini functions as they stand are worthless.
>> What I'm not getting is why we should care enough about that
>> to break just about everybody's extension.  Even if unloading
>> extensions were feasible, who would bother?

> Well, if we think that, then we ought to remove the NOT_USED code and
> all the random _PG_fini() stuff that's still floating around.

I think that's exactly what we should do, if it bugs you that stuff
is just sitting there.  I see no prospect that we'll ever make it
work, because the question of unhooking from hooks is just the tip
of the iceberg.  As an example, what should happen with any custom
GUCs the module has defined?  Dropping their values might not be
very nice, but if we leave them around then the next LOAD (if any)
will see a conflict.  Another fun question is whether it's ever
safe to unload a module that was preloaded by the postmaster.

In short, this seems like a can of very wriggly worms, with not
a lot of benefit that would ensue from opening it.

			regards, tom lane





view thread (71+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: make MaxBackends available in _PG_init
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox