RE: Performance Spamassin PostgreSQL vs MySQL

2009-03-20 Thread Miles Thompson
We had an awkward setup, which forced us to use PGSQL for SpamAssassin. Unfortunately the SA queries are not processed well by PGSQL. Back in January we switched SA processing to MySQL. Bingo! Instant improvement in overall performance, and no PGSQL maintenance required. This is not sophistica

Re: Performance Spamassin PostgreSQL vs MySQL

2009-03-19 Thread mos
At 02:53 PM 3/18/2009, you wrote: We are using the PostgreSQL currently to store the Bayes information. It seems to periodically spend a lot of time 'vacumming' which of course drives up disk load. The system admin has adjusted it so it only does this at low load. I'm curious if anyone has act