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
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance