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