Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why?
Date: 2005-12-22 02:14:18
Message-ID: 20051222021418.GB6026@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Madison Kelly (linux(at)alteeve(dot)com) wrote:
> If the performace difference comes from the 'COPY...' command being
> slower because of the automatic quoting can I somehow tell PostgreSQL
> that the data is pre-quoted? Could the performance difference be
> something else?

I doubt the issue is with the COPY command being slower than INSERTs
(I'd expect the opposite generally, actually...). What's the table type
of the MySQL tables? Is it MyISAM or InnoDB (I think those are the main
alternatives)? IIRC, MyISAM doesn't do ACID and isn't transaction safe,
and has problems with data reliability (aiui, equivilant to doing 'fsync
= false' for Postgres). InnoDB, again iirc, is transaction safe and
whatnot, and more akin to the default PostgreSQL setup.

I expect some others will comment along these lines too, if my response
isn't entirely clear. :)

Stephen

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Brown 2005-12-22 02:44:53 Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why?
Previous Message Michael Fuhr 2005-12-22 02:13:46 Re: Speed of different procedural language