temporarily deactivate an index - Mailing list pgsql-general

From Viktor Rosenfeld
Subject temporarily deactivate an index
Date
Msg-id 788F92AD-B6E7-426D-9D4B-314CA7806BD5@informatik.hu-berlin.de
Whole thread Raw
Responses Re: temporarily deactivate an index  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Hi,

I'm experimenting with different indexes to speed up my queries and I
was wondering if it is possible to temporarily deactivate an index, so
it won't be considered in the evaluation of query plans.  The reason
is that dropping and then rebuilding an index takes up time which I
would rather not wait.

I couldn't find a command to do that, but I'm guessing that it should
be possible by manipulating a structure in the catalog?

Thanks,
Viktor

pgsql-general by date:

Previous
From: "Adam Rich"
Date:
Subject: Re: IN vs EXISTS
Next
From: Jeremy Harris
Date:
Subject: Re: when to reindex?