temporarily deactivate an index

From: Viktor Rosenfeld <rosenfel(at)informatik(dot)hu-berlin(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: temporarily deactivate an index
Date: 2008-06-07 14:05:47
Message-ID: 788F92AD-B6E7-426D-9D4B-314CA7806BD5@informatik.hu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Harris 2008-06-07 14:37:12 Re: when to reindex?
Previous Message Adam Rich 2008-06-07 13:59:11 Re: IN vs EXISTS