From: Joe <svn@freedomcircle.net>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Comparative performance
Date: Tue, 04 Oct 2005 17:11:19 -0400
Message-ID: <4342EFF7.5010405@freedomcircle.net> (raw)
In-Reply-To: <20051004204122.GV40138@pervasive.com>
References: <433B4AA4.9080008@freedomcircle.net>
<op.sxu1g5bnth1vuj@localhost>
<433BDFF3.3090402@freedomcircle.net>
<433BEA7B.1050405@pse-consulting.de>
<433C5108.6070202@freedomcircle.net>
<20051004204122.GV40138@pervasive.com>
Hi Jim,
Jim C. Nasby wrote:
> Also, just because no one else has mentioned it, remember that it's very
> easy to get MySQL into a mode where you have no data integrity. If
> that's the case it's going to be faster than PostgreSQL (though I'm not
> sure how much that affects the performance of SELECTs).
Yes indeed. When I added the REFERENCES to the schema and reran the conversion
scripts, aside from having to reorder the table creation and loading (they used
to be in alphabetical order), I also found a few referential integrity errors in
the MySQL data.
Joe
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: svn@freedomcircle.net, jnasby@pervasive.com, pgadmin@pse-consulting.de
Subject: Re: Comparative performance
In-Reply-To: <4342EFF7.5010405@freedomcircle.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