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

Re: Postgres vs. MySQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Evilio del Rio <edelrio(at)cmima(dot)csic(dot)es>
Cc: dspam-users(at)networkdweebs(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres vs. MySQL
Date: 2004-11-24 15:57:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Evilio del Rio wrote:

>I have installed the dspam filter
>( 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.


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(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (285 bytes)

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2004-11-24 16:06:23
Subject: Re: memcached and PostgreSQL
Previous:From: Alexandre LeclercDate: 2004-11-24 15:39:03
Subject: Re: Data type to use for primary key

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