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

Reply via email to