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

Reply via email to