Re: Invisible Indexes - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Invisible Indexes
Date
Msg-id CAH2-WzkeDCgRSYmE4eKZ92KDJk4CpK9x7B8e1c3774CmpAdGGg@mail.gmail.com
Whole thread Raw
In response to Invisible Indexes  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: Invisible Indexes
List pgsql-hackers
On Mon, Jun 18, 2018 at 2:36 PM, Andrew Dunstan
<andrew.dunstan@2ndquadrant.com> wrote:
>
> This is a MySQL feature, where an index is not considered by the planner.
> Implementing it should be fairly straightforward, adding a new boolean to
> pg_index, and options to CREATE INDEX and ALTER INDEX. I guess VISIBLE would
> become a new unreserved keyword.

> So, do we want this feature? If we do I'll go ahead and prepare a patch.

I know that it's definitely a feature that I want. Haven't thought
about the syntax, though.

-- 
Peter Geoghegan


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Invisible Indexes
Next
From: Jaime Casanova
Date:
Subject: Re: Invisible Indexes