> Hi Scott,
> Am 07.06.2008 um 16:53 schrieb Scott Marlowe:
>>> 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
>>> be considered in the evaluation of query plans. The reason is that
>>> 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?
>> Try this:
>> drop indexname;
>> explain analyze select ...;
> That works, but I'm still looking for another way to deactivate the index.
> The reason being, that my query load is randomly generated by a Java
> program and I don't want to go and change the SQL compiler.
Sorry, I'm out of ideas. I mean, you can turn off all indexes with
set enable_indexscan=off but there's no other way to do it cheaply and
in such a fine grained way.
Sent via pgsql-general mailing list (firstname.lastname@example.org)
To make changes to your subscription: