Re: Not Picking Index

"George Pavlov" <gpavlov(at)mynewplace(dot)com> writes:
>> In PG 8.2 and up there is a sneakier way to do it that won't acquire
>> any more lock than the statement-under-test does:
>>
>> begin;
>> update pg_index set indisvalid = false
>> where indexrelid = 'soandso'::regclass;
>> explain analyze ...;
>> rollback;

> this really smacks of that four-letter word that starts with h... -- i
> am glad we have finally come around on the subject :-)

indisvalid isn't a hint; it was necessary to make CREATE INDEX CONCURRENTLY
work. But if you want to (mis?)use it as a hint, you can ...

regards, tom lane