On Mon, Feb 24, 2003 at 03:53:14PM -0500, Ericson Smith wrote:
>
> Will we be able to run the new vacuum system without locking the tables?
I believe the new vacuum stuff is just to help on btree indexes. The
current vacuum doesn't lock the tables, either.
> Currently our database is at about 15gigs. Over the period of a month,
> it grows to about 25gigs (10Gb wasted space). Every month we have a
> cleanup routine which involves copying the most actively updated tables
> to text, and importing the data again. We vacuum every night and analyze
> 4 times per day, but we're loath to do a VACUUM FULL because of the
> table locking issues (locking some of the tables would break the
It sounds like either your free space map is not set correctly, or
you have ever-growing indexes. Reindexing would be enough for this
problem. There are still some 24/7-operation problems with having to
reindex.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
