Re: Invisible Indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Invisible Indexes
Date
Msg-id 20405.1529848755@sss.pgh.pa.us
Whole thread Raw
In response to Re: Invisible Indexes  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: Invisible Indexes
List pgsql-hackers
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> A major downside to a GUC is that you have to be aware of the current 
> setting, since we're not going to have one settoing for each invisible 
> index. Doing it at the SQL level you can treat each index separately. A 
> GUC will actually involve more code, I suspect.

I'd envision it being a list of index names.  We already have most
if not all of the underpinnings for such a thing, I believe, lurking
around the code for search_path, temp_tablespaces, etc.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Concurrency bug in UPDATE of partition-key
Next
From: Fabien COELHO
Date:
Subject: Re: Desirability of client-side expressions in psql?