Re: [dspam-users] MySQL vs. PgSQL

taras@elantech.ru wrote:
> Hi to all!
> I have about ~4000 users in mysql-4.1 (FreeBSD) and seems quite bad
> behavior of mysql under havy load. May be switching to PostgreSQL can
> help me?

No, PostgreSQL will probably be [much] worse. Did you tune your MySQL
instances for heavy usage (there should be multiple my*.cnf example
files included with the package). Try my-medium.cnf, my-large.cnf, or
even my-huge.cnf. You did read the wiki page on tuning:

        http://dspamwiki.expass.de/Performance_Tuning

didn't you? Also make sure that you optimize tables on a regular basis
(e.g. with your monthly purge run); this alone can be a 500% increase in
performance, as mysql will be more efficient once you have optimized the
tables under actual usage.

John

-- 
John Peacock
Director of Information Research and Technology
Rowman & Littlefield Publishing Group
4501 Forbes Boulevard
Suite H
Lanham, MD  20706
301-459-3366 x.5010
fax 301-429-5748