X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 72CA4DA0BF for ; Tue, 4 Oct 2005 18:11:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79602-07 for ; Tue, 4 Oct 2005 21:11:09 +0000 (GMT) Received: from cluster1.echolabs.net (smtp-out.echolabs.net [216.52.118.200]) by svr1.postgresql.org (Postfix) with ESMTP id 4B340DA0AF for ; Tue, 4 Oct 2005 18:11:08 -0300 (ADT) X-Scanned-By: RAE MPP/Clamd http://www.messagepartners.com X-Scanned-By: RAE MPP/Cloudmark http://www.messagepartners.com Received: from [216.189.176.72] (account jma@atlanticbb.net HELO [127.0.0.1]) by fe3.cluster1.echolabs.net (CommuniGate Pro SMTP 4.3.7) with ESMTPA id 2756355; Tue, 04 Oct 2005 17:05:25 -0400 Message-ID: <4342EFF7.5010405@freedomcircle.net> Date: Tue, 04 Oct 2005 17:11:19 -0400 From: Joe Organization: Freedom Circle, LLC User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" Cc: Andreas Pflug , pgsql-performance@postgresql.org Subject: Re: Comparative performance References: <433B4AA4.9080008@freedomcircle.net> <433BDFF3.3090402@freedomcircle.net> <433BEA7B.1050405@pse-consulting.de> <433C5108.6070202@freedomcircle.net> <20051004204122.GV40138@pervasive.com> In-Reply-To: <20051004204122.GV40138@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.045 required=5 tests=[AWL=0.045] X-Spam-Level: X-Archive-Number: 200510/49 X-Sequence-Number: 14817 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