[imp] mysql vs. postgres..

[David A Powicki]

It's 15:15 EST, I vacuum every morning at 04:00 and here is state of
things:

shell> ls -lat /usr/local/postgres/data/base/horde

-rw------- 1 postgres staff 38641664 Nov 8 15:15 active_sessions
-rw-------   1 postgres staff 66535424 Nov  8 15:15active_sessions_pkey           
.
.
.
.

I'm looking at DB bloat of ~70MB per day.  This is created by ~4200
sessions per day.

I'm willing to consider that I have the DB setup incorrectly, because this
type of DB bloat seems attrociuos....

David


> On Wed, 8 Nov 2000, Martin A. Marques wrote:
> 
> > On Mié 08 Nov 2000 17:07, you wrote:
> > > I have been running IMP 2.2.0 with Postgres in production for about 6
> > > months now.  Other than the major annoyance of having to vacuum the
> > > DB nightly (a task that takes in excess of  20 minutes on an E250 wit=
h 1
> > > GB of ram and dual 300 CPUs) Postgres has worked very well.  Currentl=
y I
> > > am getting a 2.2.3 version of IMP  up and running.  This time I plan =
to
> > > use Mysql in order to avoid the need to Vacuum.    A few minutes ago
> > > I reread the section of the FAQ concern which DB to use.
> > 
> > Why is it that you vacumm every night? I use postgres with no problem, =
and 
> > have never had to vacumm. Maybe I'm missing something.
> 
> I vacuum once in a blue moon when I happen to remeber to do it ... and it
> doesn't take 20minutes on a Dual-PIII with 768Meg of RAM ... how big is
> your horde database??
> 
> 
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
>