Re: Postgres vs. MySQL

From: Steinar H. Gunderson
Subject: Re: Postgres vs. MySQL
Date: ,
Msg-id: 20041124141615.GB28960@uio.no
(view: Whole thread, Raw)
In response to: Postgres vs. MySQL  (Evilio del Rio)
List: pgsql-performance

Tree view

Postgres vs. MySQL  (Evilio del Rio, )
 Re: Postgres vs. MySQL  ("Steinar H. Gunderson", )
 Re: Postgres vs. MySQL  (Richard Huxton, )
 Re: Postgres vs. MySQL  (Christian Fowler, )
  Re: Postgres vs. MySQL  ("Steinar H. Gunderson", )
   Re: Postgres vs. MySQL  (Dave Cramer, )
 Re: Postgres vs. MySQL  ("Joshua D. Drake", )
 Re: Postgres vs. MySQL  ("Steinar H. Gunderson", )
 Re: Postgres vs. DSpam  (Andrew McMillan, )
  Re: Postgres vs. DSpam  (Neil Conway, )
  Re: Postgres vs. DSpam  ("Jim C. Nasby", )
 Re: [dspam-users] Postgres vs. MySQL  (Clifton Royston, )
  Re: [dspam-users] Postgres vs. MySQL  ("Casey Allen Shobe", )
   Re: [dspam-users] Postgres vs. MySQL  (Lionel Bouton, )
 Re: [dspam-users] Postgres vs. MySQL  (Christopher Browne, )

On Wed, Nov 24, 2004 at 02:14:18PM +0100, Evilio del Rio wrote:
> It's incredible! the same servers, the same messages, the same dspam
> compilation (well each one with the corresponding
> --with-storage-driver=*sql_drv). Postgres is getting worst than
> 30s/message and MySQL process the same in less than a second.

AFAIK dspam is heavily optimized for MySQL and not optimized for PostgreSQL
at all; I believe there would be significant performance boosts available
by "fixing" dspam.

Example queries that are slow, as well as table schemas, would probably help
a lot in tracking down the problems.

/* Steinar */
--
Homepage: http://www.sesse.net/


pgsql-performance by date:

From: "gnari"
Date:
Subject: Re: FW: Index usage
From: Mike Mascari
Date:
Subject: Re: Slow execution time when querying view with WHERE clause