I ran dbmail-util -ay, is this what you mean? Or something else? I am
running postgresql 7.4 and would be very interested in the steps taken to
full-vacuum analyze. Also what steps did you take to "tune" the database?
Thanks very much for the help,
Eric
From: Tom Allison <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <dbmail@dbmail.org>
To: DBMail mailinglist <dbmail@dbmail.org>
Subject: Re: [Dbmail] Extremely slow performance with 2.2.1 + postgresql
Date: Sat, 25 Nov 2006 19:41:02 -0500
Leonel Nunez wrote:
did you vacuum analize the database ??
leonel
Yeah... I found that my original assessment of dbmail was, "Gosh, this
really sucks" but that was before I did any tuning of the database.
After I tuned the database it was still really depressing.
Then I realized that the autovacuum process under postgres wasn't turned
on...
Ran a VACUUM FULL ANALYZE on it...
It was immediately better.
Within an hour it was much better.
Now it's great.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
Fixing up the home? Live Search can help
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG