On 11 December 2015 at 22:03, Joshua D. Drake <j...@commandprompt.com> wrote: > On 12/11/2015 06:25 PM, Tatsuo Ishii wrote: > >> What about inventing a new SET command something like: >> >> SET disabled_index to <index-name> >> >> This adds <index-name> to "disabled index list". The disabled index >> list let the planner to disregard the indexes in the list. >> >> SET enabled_index to <index-name> >> >> This removes <index-name> from the disabled index list. >> >> SHOW disabled_index >> >> This shows the content of the disabled index list. > > > Wouldn't something like: > > ALTER INDEX foo SET DISABLED; > > See more in line with our grammar? > > I assume the index is only disabled as far as the planner is concerned and > all updates/inserts/deletes will still actually update the index > appropriately? >
BTW, you can do that today with UPDATE pg_index SET indisvalid = false WHERE indexrelid = 'indexname'::regclass; -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitaciĆ³n -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers