| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-11-24 14:27:06 | Re: Postgres vs. MySQL |
| Previous Message | Evilio del Rio | 2004-11-24 13:14:18 | Postgres vs. MySQL |