Adam Brusselback <adambrusselback@xxxxxxxxx> writes: > Is there any easy way I can know if an index is usable or not? Are there > any catalog views or anything I could check that in? IIRC, you can look at pg_index.indcheckxmin --- if that's set, then the index had broken HOT chains during creation and may not be usable right away. Telling whether your own transaction can use it is harder from SQL level, but if you're in the same transaction that made the index then the answer is probably always "no" :-( regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
