[Mimedefang] Mail::SpamAssassin::BayesStore::SQL database persistence.

Matthew Schumacher matt.s at aptalaska.net
Thu Jul 21 01:50:25 EDT 2005


Sevo Stille wrote:
> Matthew Schumacher wrote:

> 
> At any rate with my installation, SA/pg seems to be mostly slowed down
> by the fact that the database is poorly indexed - indexing the most
> significant search fields (bayes_seen(msgid), bayes_token(token) and id
> throughout all tables) and doing a vacuum optimize run did improve
> performance quite significantly.

Would you mind sharing your updated schema so that we can see what
indexing you did.  My installation seems fine right up until it goes to
expire data, then it goes into suck mode.

schu



More information about the MIMEDefang mailing list