Skip site navigation (1) Skip section navigation (2)

Re: Performance problems testing with Spamassassin 3.1.0

From: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>
To: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Date: 2005-07-29 05:10:07
Message-ID: 42E9BA2F.1090900@aptalaska.net (view raw or flat)
Thread:
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

In response to

Responses

pgsql-performance by date

Next:From: Chris TraversDate: 2005-07-29 05:23:15
Subject: Re: Left joining against two empty tables makes a query
Previous:From: Gnanavel SDate: 2005-07-29 04:38:49
Subject: Re: Two queries are better than one?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group