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: (view raw, whole thread or download thread mbox)
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?



In response to


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-2017 The PostgreSQL Global Development Group