Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig James
Subject auto-vacuum vs. full table update
Date
Msg-id CAFwQ8rd6G0r5oTTo=S=ONTHD797O_9NQLbAybTurPZE3i5ob5g@mail.gmail.com
Whole thread Raw
Responses Re: auto-vacuum vs. full table update
Re: auto-vacuum vs. full table update
Re: auto-vacuum vs. full table update
List pgsql-performance
Tree view 
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.

Thanks,
Craig

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: query optimization
Next
From: "Joshua D. Drake"
Date:
Subject: Re: auto-vacuum vs. full table update