Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
Дата
Msg-id aIGPsNJszufhHq4X@paquier.xyz
обсуждение исходный текст
Ответ на Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX  (Sami Imseih <samimseih@gmail.com>)
Ответы Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
Список pgsql-hackers
On Tue, Jul 22, 2025 at 01:15:16PM -0500, Sami Imseih wrote:
> The GUC serves multiple purposes. For example,I can create an index as invisible
> and use it in a controlled way, which is helpful for experimenting
> with a new index.

An in-core GUC to control the list of indexes that should be allowed
or disallowed is I think asking for trouble, adding schema-related
knowledge directly into the GUC machinery.  This does not scale well,
even if you force all the entries to be specified down to the database
and the schema.  And it makes harder to control what a "good" behavior
should be at query-level.

My 2c.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления: