Leo Mannhart <leo.mannhart@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
