From: Stephen Frost <sfrost@snowman.net>
To: Madison Kelly <linux@alteeve.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why?
Date: Wed, 21 Dec 2005 21:14:18 -0500
Message-ID: <20051222021418.GB6026@ns.snowman.net> (raw)
In-Reply-To: <43AA0966.6090401@alteeve.com>
References: <43AA0966.6090401@alteeve.com>
* Madison Kelly (linux@alteeve.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
Attachments:
signature.asc (application/pgp-signature, 188B) download
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: sfrost@snowman.net, linux@alteeve.com
Subject: Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why?
In-Reply-To: <20051222021418.GB6026@ns.snowman.net>
* 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