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