Re: Data Warehouse Reevaluation - MySQL vs Postgres --

From: "Leeuw van der, Tim" <tim(dot)leeuwvander(at)nl(dot)unisys(dot)com>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, "PostgreSQL Performance List" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: 2004-09-14 14:00:58
Message-ID: BF88DF69D9E2884B9BE5160DB2B97A85010D6D62@nlshl-exch1.eu.uis.unisys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org]On Behalf Of Steinar H. Gunderson
Sent: Tuesday, September 14, 2004 3:33 PM
To: PostgreSQL Performance List
Subject: Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres --

> On Tue, Sep 14, 2004 at 02:42:20PM +0200, Leeuw van der, Tim wrote:
> > - PostgreSQL 7.3 running on CYGWIN with cygipc daemon
>
> Isn't this doomed to kill your performance anyhow?

Yes and no, therefore I mentioned it explicitly as one of the caveats. When doing selects I could get performance very comparable to MySQL, so I don't want to blame poor insert-performance on cygwin/cygipc per se.
I'm not working on this app. anymore and don't have a working test-environment for it anymore so I cannot retest now with more recent versions.

regards,

--Tim

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Harald Fuchs 2004-09-14 14:15:43 Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Previous Message Steinar H. Gunderson 2004-09-14 13:33:05 Re: Data Warehouse Reevaluation - MySQL vs Postgres --