Re: how to gate experimental features (SQL/PGQ)

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Subject: Re: how to gate experimental features (SQL/PGQ)
Date: 2026-01-15 08:53:10
Message-ID: 05A3D189-654E-4472-B275-4C6734EBB080@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 14 Jan 2026, at 22:15, Matheus Alcantara <matheusssilv97(at)gmail(dot)com> wrote:
>
> On 14/01/26 17:57, Daniel Gustafsson wrote:
>>> On 13 Jan 2026, at 15:16, Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:
>>> 2) A run-time setting (GUC) like experimental_pgq = on/off. This would be checked in the relevant DDL (CREATE/ALTER/DROP) commands as well as the GRAPH_TABLE function. So without that you couldn't do anything with it, but for example pg_dump and psql and ecpg preproc would still work and the system catalogs exist. Default to off for one release (subject to change).
>> Such a GUC would IMHO only make sense if we remove it when we promote the
>> feature, but removing a GUC also comes with a cost for anyone having baked it
>> into their scripts etc. If we feel confident enough that a patch satisfies the
>> security requirements to merge it, I think we should make it available.
> Instead of having a GUC for each potential experimental feature we could have just a single GUC with a list of experimental features that are enabled.
>
> SET enable_experimental_features = "foo,bar,baz";

That is an option to avoid the need to retire/remove GUC's. Such a format
makes it harder to know which experimental features which are disabled when
querying pg_settings or looking at it in other ways where the postgresql.conf
comment isn't immediately visible, but that might not be a big concern.

--
Daniel Gustafsson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-01-15 08:57:00 Re: Extended Statistics set/restore/clear functions.
Previous Message Japin Li 2026-01-15 08:39:37 Re: GIN pageinspect support for entry tree and posting tree