Craig James <cjames@xxxxxxxxxxxxxx> wrote: > An update to our system means I'm going to be rewriting every row > of some large tables (20 million rows by 15 columns). In a > situation like this, can auto-vacuum take care of it, or should I > plan on vacuum-full/reindex to clean up? > > This is 8.4.4. If there is any way for you to update in "chunks", with a vacuum after each chunk, that will prevent the extreme bloat. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
