Howdy all! Quick question regarding REINDEX. I have a large table with 1077455 rows. I have an index on the table with a WHERE clause that limits the rows to around 10-50. When I REINDEX this index, it takes on the order of a minute to do the reindex. Question: Does a REINDEX use the old version to build the new version, or is it the semantic equivalent to "drop index; build new index". If the first, any thoughts on why it is taking so long to reindex? If the second, any particular reason not to use the current (though possibly bloated) index to reduce work (essentially, all we are doing is recompacting the same info as the original index with a rebalance)? Regards! Ed ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
