Re: 7.4?

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