Alvaro Herrera <alvherre@xxxxxxxxxxxxx> writes: > Which reminds me that you wanted to make VACUUM FULL do the equivalent > of a REINDEX instead of retail deletion of index entries ... is that > still the idea? Would it do that always, or only under certain > conditions? It's still on the to-do list. I ws envisioning that it would switch strategies based on how many tuples it needed to move --- the REINDEX is only a win if you're moving a large fraction of the table. But the details are all still TBD. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)