> If you are updating a large portion of your tree, you will probably want to throw in a vacuum in > between the two updates. This should reduce the bloat caused by dead tuples in both your index > and table. ... but that will only work if you can commit the first set of changes before you get to the end result, possibly having an inconsistent state for the duration of the vacuum... if you want all in one transaction, vacuum will not help. Cheers, Csaba.
