From: Michael Kleiser <mkl@webde-ag.de>
To: Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
Cc: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: PostgreSQL Performance List <pgsql-performance@postgresql.org>
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: Tue, 14 Sep 2004 16:23:02 +0200
Message-ID: <4146FEC6.2040007@webde-ag.de> (raw)
In-Reply-To: <BF88DF69D9E2884B9BE5160DB2B97A85010D6D62@nlshl-exch1.eu.uis.unisys.com>
References: <BF88DF69D9E2884B9BE5160DB2B97A85010D6D62@nlshl-exch1.eu.uis.unisys.com>
What MySQl-table-type did you use?
Was it "MyISAM" which don't supports transactions ?
Yes I read about that bulk-inserts with this table-type are very fast.
In Data Warehouse one often don't need transactions.
Leeuw van der, Tim schrieb:
>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mkl@webde-ag.de, tim.leeuwvander@nl.unisys.com, sgunderson@bigfoot.com
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
In-Reply-To: <4146FEC6.2040007@webde-ag.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox