Re: Data Warehouse Reevaluation - MySQL vs Postgres -- - Mailing list pgsql-performance

From Leeuw van der, Tim
Subject Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date
Msg-id BF88DF69D9E2884B9BE5160DB2B97A85010D6D63@nlshl-exch1.eu.uis.unisys.com
Whole thread Raw
List pgsql-performance
Hi,

-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Michael
Kleiser
Sent: Tuesday, September 14, 2004 4:23 PM
To: Leeuw van der, Tim
Cc: Steinar H. Gunderson; PostgreSQL Performance List
Subject: Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres --


> 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.

Although totally beyond the scope of this thread, we used InnoDB tables with MySQL because of the transaction-support.

regards,

--Tim

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables
Next
From: Christopher Browne
Date:
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --