Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Matthew Schumacher <matt.s@aptalaska.net>
Date: 2005-07-28T00:12:15Z
Lists: pgsql-performance
Matt,

> After playing with various indexes and what not I simply am unable to
> make this procedure perform any better.  Perhaps someone on the list can
> spot the bottleneck and reveal why this procedure isn't performing that
> well or ways to make it better.

Well, my first thought is that this is a pretty complicated procedure for 
something you want to peform well.    Is all this logic really necessary?   
How does it get done for MySQL?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco