> 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?
But this will affect other sessions, no? > 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? Yes. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers