Sometimes I need to repeat creating and dropping indexes while doing an SQL tuning work. As you might know, creating a large index takes long time. So dropping the index and re-creating it is pain and counter productive.
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. 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
