Re: database file size bloat

Matthew Arnison wrote:
>
> the bloat is a big problem. i just checked it again, and the db has
> balloooned to 20 megs again, with i think 2650 unused pages. this is after
> vacuuming it last night. i guess we need to setup the vacuum script to run
> every hour. i am worried about this locking out users during the
> vacuuming, although i guess if it happens more often, it should take less
> time.

I should add that my vacuum runs don't take very long (< 10 seconds).  I
would have to consider other alternatives if it took much longer...

> meanwhile, as for upgrading, i think i'll try 6.5.3 first.
>
> version 7 is still in beta. is it atleast as stable as 6.5.3? is it
> atleast as fast as 6.5.3?

Beta3 is more stable and much faster, IMO.  Haven't tried beta5.