pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Evilio del Rio <edelrio@cmima.csic.es>
Cc: dspam-users@networkdweebs.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres vs. MySQL
Date: Wed, 24 Nov 2004 07:57:00 -0800
Message-ID: <41A4AF4C.60404@commandprompt.com> (raw)
In-Reply-To: <1101302058.338.74.camel@haddock.cmima.csic.es>
References: <1101302058.338.74.camel@haddock.cmima.csic.es>

Evilio del Rio wrote:

>Hi,
>
>I have installed the dspam filter
>(http://www.nuclearelephant.com/projects/dspam) on our mail server
>(RedHat 7.3 Linux with sendmail 8.13 and procmail). I have ~300 users
>with a quite low traffic of 4000 messages/day. So it's a quite common
>platform/environment, nothing spectacular.
>
>  
>
The problem is definately dspam. We have been through their code.
The new version is much, much better than the older one but I am sure
there is more work to be done.

The first version we installed suffered from a well known problem:

It would use smallint/bigint but would not cast or quote the
where clauses and thus PostgreSQL would never use the indexes.

It was also missing several indexes on appropriate columns.

We offered some advice and we know that some of it was taken but
we don't know which.

Sincerely,

Joshua D. Drake



-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard

view thread (12+ messages)  latest in thread

Message-ID: <41A4AF4C.60404@commandprompt.com>
Permalink:  ../41A4AF4C.60404@commandprompt.com/
Also on:    postgresql.org/message-id/41A4AF4C.60404@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, edelrio@cmima.csic.es, dspam-users@networkdweebs.com
  Subject: Re: Postgres vs. MySQL
  In-Reply-To: <41A4AF4C.60404@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox