X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B1863329D58 for ; Tue, 14 Sep 2004 15:24:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81308-10 for ; Tue, 14 Sep 2004 14:23:53 +0000 (GMT) Received: from mailgate3.cinetic.de (mailgate3.cinetic.de [217.72.192.164]) by svr1.postgresql.org (Postfix) with ESMTP id DD19F329D3E for ; Tue, 14 Sep 2004 15:23:53 +0100 (BST) Received: from exchange02.int.cinetic.de (exchange02.int.cinetic.de [10.2.1.12]) by mailgate3.cinetic.de (8.11.6p2/8.11.2/SuSE Linux 8.11.0-0.4) with ESMTP id i8EEN4K06232; Tue, 14 Sep 2004 16:23:04 +0200 Received: from [10.1.8.177] ([10.1.8.177]) by exchange02.int.cinetic.de with Microsoft SMTPSVC(6.0.3790.0); Tue, 14 Sep 2004 16:23:03 +0200 Message-ID: <4146FEC6.2040007@webde-ag.de> Date: Tue, 14 Sep 2004 16:23:02 +0200 From: Michael Kleiser Reply-To: mkl@webde-ag.de Organization: WEB.DE AG User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.2) Gecko/20040803 X-Accept-Language: de, , de-de, de-at, en, en-us MIME-Version: 1.0 To: "Leeuw van der, Tim" Cc: "Steinar H. Gunderson" , PostgreSQL Performance List Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 14 Sep 2004 14:23:03.0587 (UTC) FILETIME=[58880F30:01C49A66] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/119 X-Sequence-Number: 8247 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) >