"George Pavlov" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq