> >postgreSQL v8.0.4 SM writes: > Upgrade to Postgresql 8.1.4 if you can. Turn on autovacuum. > Use BayesStore::PgSQL.
Very good advice. As an interesting side-information, I can say that when using pen-pals whitelisting with amavisd-new, SQL database maintenance operations (purging old records) is about an order of magnitude faster with PostgreSQL 8.1.4 compared to MySQL 4.1.20. Mark