Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
Date
Msg-id CAA5RZ0vybarroqJ7buqpZx_0poiPCoZS3CgbnfJ=cgM2ErXM7Q@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX  (Robert Treat <rob@xzilla.net>)
Responses Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
List pgsql-hackers
> it will still be extremely risky in
> heavy production workloads. In short, we're both walking a bull
> through the china shop, but it would seem mine is much more
> temperamental than yours.

Robert, Could you describe the GUC you would like to see?

Also, I'd like to ask. what would be the argument against offering both options,
ALTER and a GUC to override the catalog, as currently proposed in the patch?

This conversation has been mainly GUC is better than ALTER, or vice versa.

It is clear, at least to me, there are merits in both approaches, so
what would be
the argument against making both options available ( maybe with a GUC that
could be more useful than a simple boolean )?

--

Sami



pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: Re: POC: Parallel processing of indexes in autovacuum
Next
From: Shlok Kyal
Date:
Subject: Update Examples in Logical Replication Docs