| index | insert | reindex | | ------------ | -------| --------| | uidx | -3% | +0.9% | | ccl | -8.5% | -21.3% | | ccl_collated | -9.7% | -18.6% | | accl | -13.8% | -31.4% | | tnt | -3.4% | +0.4% | | worstcase | -74.6% | -86.2% | Notes: - the "worstcase" index took longer to REINDEX than it took to INSERT on HEAD, the origin of which I haven't discovered yet. It is unlikely to be commit status checks on the table, because no other REINDEX took as long as the difference between INSERT and REINDEX, while having the exact same data having been loaded into the table. - "tnt" reindex load was faster, even though I hadn't expected that to be the case.