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

Re: Postgres vs. MySQL

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres vs. MySQL
Date: 2004-11-24 14:16:15
Message-ID: 20041124141615.GB28960@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

pgsql-performance by date

Next:From: Richard HuxtonDate: 2004-11-24 14:27:06
Subject: Re: Postgres vs. MySQL
Previous:From: Evilio del RioDate: 2004-11-24 13:14:18
Subject: Postgres vs. MySQL

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