Benjamin Arai <benjamin@xxxxxxxxxxxx> writes: > I would prefer not to drop the index because the database is several > hundred gigs. I would prefer to incrementally add to the index. This may well be false economy. I don't have numbers at hand, but a full rebuild can be substantially faster than adding a large number of rows to the index incrementally. Also, you don't end up with a physically disordered index, so there is some ongoing performance benefit. regards, tom lane
