Re: Performance problems testing with Spamassassin 3.1.0 Bayes module. - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.
Date
Msg-id 200507271712.15299.josh@agliodbs.com
Whole thread Raw
In response to Performance problems testing with Spamassassin 3.1.0 Bayes module.  (Matthew Schumacher <matt.s@aptalaska.net>)
Responses Re: Performance problems testing with Spamassassin 3.1.0
List 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

pgsql-performance by date:

Previous
From: Matthew Schumacher
Date:
Subject: Performance problems testing with Spamassassin 3.1.0 Bayes module.
Next
From: Tom Lane
Date:
Subject: Re: [Bizgres-general] Re: faster INSERT with possible