Re: Performance problems testing with Spamassassin 3.1.0

Matthew Schumacher <matt.s@aptalaska.net>

From: Matthew Schumacher <matt.s@aptalaska.net>
To: Gavin Sherry <swm@alcove.com.au>
Cc: pgsql-performance@postgresql.org
Date: 2005-07-29T05:10:07Z
Lists: pgsql-performance
Gavin Sherry wrote:

> 
> I had a look at your data -- thanks.
> 
> I have a question though: put_token() is invoked 120596 times in your
> benchmark... for 616 messages. That's nearly 200 queries (not even
> counting the 1-8 (??) inside the function itself) per message. Something
> doesn't seem right there....
> 
> Gavin

I am pretty sure that's right because it is doing word statistics on
email messages.

I need to spend some time studying the code, I just haven't found time yet.

Would it be safe to say that there isn't any glaring performance
penalties other than the sheer volume of queries?

Thanks,

schu