Re: [PERFORM] auto-vacuum vs. full table update

2012-04-26 Thread Kevin Grittner
Craig James 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

Re: [PERFORM] auto-vacuum vs. full table update

2012-04-26 Thread Steve Crawford
On 04/26/2012 12:49 PM, Craig James 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? If you want to recla

Re: [PERFORM] auto-vacuum vs. full table update

2012-04-26 Thread Joshua D. Drake
On 04/26/2012 12:49 PM, Craig James 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? If you rewrite t