On Sat, May 04, 2002 at 06:50:17PM -0700, Sean Chittenden wrote:
> > I ran this experiment for 10 minutes. At time 0 the database size
> > was 2MB. At 60 seconds the size was 22MB. The size continued
> > upward:
> >
> > Time | Size
> > 0 2
> > 60 7
> > 120 60
> > 180 109
> > 240 181
> > 300 282
> > 360 284
> > 420 363
> > 480 442
> > 540 549
> > 600 557
>
> This may be outisde of the possibility of your environment, but have
> you tried a VACUUM FULL or VACUUM FREEZE ? -sc
As I've said before, dump and reload is MUCH faster than vacuum
full, and they both require the same exclusive access. Therefore
vacuum full isn't any better than my current situation.
-jwb