Re: postres bayes db and high load

[Dan]

I do use BayesStore::PgSQL and although I don't have autovacuum turned on, I do vacuum the database nightly (as well as a weekly vacuum full).

I didn't know that 8.1 offered was that much faster, but it's worth a shot.  I'll also have to check out amavisd-new 2.4.  The pen-pal whitelisting sounds good.

Thanks,

Dan

On 8/4/06, Mark Martinec < [EMAIL PROTECTED]> wrote:

> >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