Harry Mantheakis <harry.mantheakis@xxxxxxxxxxxxxxxxxxxxxx> wrote: > I have stopped the all-in-one-go update from executing, and now I > am executing a series of statements, each constrained to update no > more than 100,000 records at a time. > > Interesting fact: updating 100,000 rows takes 5 seconds. Quick. One last thing -- all these updates, included the aborted attempt at a single-pass update, may cause significant bloat in both the heap and the index(es). I usually finish up with a CLUSTER on the table, followed by a VACUUM ANALYZE on the table. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
