Harry Mantheakis <harry(dot)mantheakis(at)riskcontrollimited(dot)com> wrote:
> I have stopped the all-in-one-go update from executing, and now I
> am executing a series of statements, each constrained to update no
> more than 100,000 records at a time.
>
> Interesting fact: updating 100,000 rows takes 5 seconds. Quick.
One last thing -- all these updates, included the aborted attempt at
a single-pass update, may cause significant bloat in both the heap
and the index(es). I usually finish up with a CLUSTER on the table,
followed by a VACUUM ANALYZE on the table.
-Kevin