Craig James <cjames(at)emolecules(dot)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.
In response to
pgsql-performance by date
|Next:||From: Andrew Dunstan||Date: 2012-04-26 20:27:38|
|Subject: Re: query optimization|
|Previous:||From: Tom Lane||Date: 2012-04-26 20:08:55|
|Subject: Re: query optimization |