Re: vacuum_truncate configuration parameter and isset_offset - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: vacuum_truncate configuration parameter and isset_offset
Date
Msg-id CAKFQuwbEh+viEX+UpBDb0TLugzZn9+Gcgzbzeh3y7FjCqYSx7g@mail.gmail.com
Whole thread Raw
In response to Re: vacuum_truncate configuration parameter and isset_offset  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
On Mon, Mar 24, 2025 at 9:41 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
TBH I'm not understanding the pushback for adding a way to determine
whether the storage parameter is actually set.  It's very simple, and it
seems like it could be useful elsewhere.

IMO this is superior to using sentinel values for the same purpose, but those already exist and having both is reasonably unappealing.

  But more importantly, it allows
us to more closely match the behavior of the existing reloptions with GUCs,
and it prevents type mismatches (e.g., the reloption is an enum but the GUC
is a Boolean).


Good point; we could solve this in documentation by simply keeping boolean if no non-boolean enum values are publicly accessible.  But this is part of why having "set/unset" not use sentinel values is better.

David J.

pgsql-hackers by date:

Previous
From: Nikolay Shaplov
Date:
Subject: Re: vacuum_truncate configuration parameter and isset_offset
Next
From: Alexander Pyhalov
Date:
Subject: Re: Add semi-join pushdown to postgres_fdw