Re: Disabling an index temporarily - Mailing list pgsql-hackers

From Victor Yegorov
Subject Re: Disabling an index temporarily
Date
Msg-id CAGnEboiBsrGee12f+UkhMzRoAjC2qWKT-8z68Df4g-2gkj1aXg@mail.gmail.com
Whole thread Raw
In response to Re: Disabling an index temporarily  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2015-12-14 5:34 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
Maybe I misunderstood, but I thought what was being discussed here is
preventing the planner from selecting an index for use in queries, while
still requiring all table updates to maintain validity of the index.

The O-ther big DBMS has `ALTER INDEX ... INVISIBLE` feature, that does exactly this.


I was thinking of a function, similar to `set_config()`, for it has `is_local` parameter, making it possible to adjust just current session or a global behavior.

`set_index(name, is_visible, is_local` perhaps?


--
Victor Y. Yegorov

pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: Proposal: custom compression methods
Next
From: Craig Ringer
Date:
Subject: Re: Proposal: custom compression methods