[imp] mysql vs. postgres..

Marc G. Fournier scrappy@hub.org
Wed, 8 Nov 2000 14:55:25 -0500 (EST)


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 with 1
> > GB of ram and dual 300 CPUs) Postgres has worked very well.  Currently 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??