Re: auto-vacuum vs. full table update - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: auto-vacuum vs. full table update
Date
Msg-id 4F99658B0200002500047411@gw.wicourts.gov
Whole thread Raw
In response to auto-vacuum vs. full table update  (Craig James <cjames@emolecules.com>)
List pgsql-performance
Craig James <cjames@emolecules.com> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: query optimization
Next
From: Andrew Dunstan
Date:
Subject: Re: query optimization