Kevin Grittner wrote: > 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 >
ouch... thanks for correcting this. ... and forgive an old man coming from Oracle ;)