I am very surprised to think that you would actually need to vacuum that often. More likely, you need to just do an analyze to keep the statistical information for the tables up to date, and only vacuum a few times a day.
On Friday 07 March 2003 15:59, Eelco van Beek - IC&S wrote: > We're running dbmail on a postgresql installation with about 22.000 > users. It has 9 Gb of maildata. For that we use postgresql. Be carefull > though, postgresql needs a lot of finetuning and vacuuming (like every > 30 mins) for it to run wel. Easier and faster is mysql with Innodb. > > Good luck, > > Eelco > > On vrijdag, maa 7, 2003, at 19:51 Europe/Amsterdam, Joby Walker wrote: > > If you are familar with the proper maintenance of pgsql, you should be > > able to do quite well. Although my installation is the opposite of > > yours (few users, large content), I have had no problems using pgsql. > > > > Joby Walker > > > > [EMAIL PROTECTED] wrote: > >> Hi all.. > >> In this day, i have played with dbmail and vpopmail and others, i > >> interesting in start a litle business in my country, ant that's > >> include > >> email with security, it's backup every mail in<->out of my client's. > >> Well in dbmail i see mysql(innodb) and postgresql, i need contact or > >> recomendations about what DB it's work better with dbmail. > >> My users it's not very demanding but I hope that they are many: > >> 2000 email user's... > >> 1 user -> quota (5M, 10M, 25M) > >> !! > >> and transfer max 4M by mail. > >> Somebody has had experience with something equal, what database one > >> better > >> perfomance for same or serious the really best one not to use dbmail > >> for > >> the same one. > >> I prefer Postgresql, because have trigers, pl/SQL and other's no to do > >> mysql!! > >> thanks > >> _______________________________________________ > >> Dbmail mailing list > >> Dbmail@dbmail.org > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > _______________________________________________ > > Dbmail mailing list > > Dbmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _________________________ > E.J.A. van Beek > ICT Manager > IC&S > T: +31 30 2322878 > F: +31 30 2322305 > > PGP-key: > www.ic-s.nl/keys/eelco.txt > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
