Re: catalog access with reset GUCs during parallel worker startup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: catalog access with reset GUCs during parallel worker startup
Date
Msg-id 1521416.1644451001@sss.pgh.pa.us
Whole thread Raw
In response to catalog access with reset GUCs during parallel worker startup  (Andres Freund <andres@anarazel.de>)
Responses Re: catalog access with reset GUCs during parallel worker startup
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Do we really need to reset GUCs to their boot value? Particularly for
> PGC_SIGHUP variables I don't think we can do that if we want to do
> RestoreGUCState() in a transaction.  It'd obviously involve a bit more code,
> but it seems entirely possible to just get rid of the reset phase?

In an EXEC_BACKEND build, they're going to start out with those
values anyway.  If you're not happy about the consequences,
"skipping the reset" is not the way to improve matters.

Can we arrange to absorb the leader's values before starting the
worker's transaction, instead of inside it?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: New developer papercut - Makefile references INSTALL
Next
From: Peter Smith
Date:
Subject: GetRelationPublicationActions. - Remove unreachable code