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

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to