Kevin Grittner wrote: > Leo Mannhart <[email protected]> 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 ;) Leo -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
