Moving thread to pgsql-performance.
On Mon, 2002-11-18 at 22:02, Adrian Calvin wrote:
> Q - If many (eg hundreds) records are deleted (purposely), those
> records get flagged for later removal. What is the best sequence of
> operations to optimize the database afterwards? Is it Vacuum,
> Re-index, then do a Vacuum Analyze.
Just run a regular vacuum once for the above. If you modify 10%+ of the
table (via single or multiple updates, deletes or inserts) then a vacuum
analyze will be useful.
Re-index when you change the tables contents a few times over. (Have
deleted or updated 30k entries in a table with 10k entries at any given
time).
General maintenance for a dataset of that size will probably simply be a
nightly vacuum, weekly vacuum analyze, and annual reindex or dump /
restore (upgrades).
--
Rod Taylor <rbt@rbt.ca>
