Josh,
> Not if it is a vacuum full and you are trying to do an insert. Which is
> exactly what
> I am talking about. Doing a vacuum full on a table that has had 5.7 million
> inserts/updates/deletes during the last 23 hours is going to cause a rather
> long vacuum full which in turn will cause a rather long period of
> unavailability
> of the database.
But if you've set it up correctly in the first place, the vacuum full won't be
necessary.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
