Leo Mannhart <leo.mannhart@beecom.ch> wrote:
> You could also try to just update the whole table in one go, it is
> probably faster than you expect.
That would, of course, bloat the table and indexes horribly. One
advantage of the incremental approach is that there is a chance for
autovacuum or scheduled vacuums to make space available for re-use
by subsequent updates.
-Kevin