X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9027911F696C for ; Tue, 28 Mar 2006 17:24:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17322-08 for ; Tue, 28 Mar 2006 17:24:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from peufeu.com (boutiquenumerique.com [82.67.9.10]) by postgresql.org (Postfix) with ESMTP id BBE6011F6796 for ; Tue, 28 Mar 2006 17:24:21 -0400 (AST) Received: (qmail 13508 invoked from network); 28 Mar 2006 23:24:30 +0200 Received: from boutiquenumerique.com (HELO apollo13) (82.67.9.10) by boutiquenumerique.com with SMTP; 28 Mar 2006 23:24:30 +0200 To: "Scott Marlowe" Cc: Marcos , pgsql-performance@postgresql.org Subject: Re: Decide between Postgresql and Mysql (help of References: <1143559902.1241.16.camel@servidor> <1143572392.3625.79.camel@state.g2switchworks.com> <1143575445.3625.87.camel@state.g2switchworks.com> Message-ID: Date: Tue, 28 Mar 2006 23:24:28 +0200 From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <1143575445.3625.87.camel@state.g2switchworks.com> User-Agent: Opera M2/8.51 (Linux, build 1462) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200603/565 X-Sequence-Number: 18002 > What really makes innodb useless to me is that there's no real support > for proper operation by MySQL itself. If you could force MySQL to only > use innodb tables, and to NEVER do the wrong things syntactically, it > would be ok. But there are thousands of foot-guns in the MySQL That's what I meant actually. And by saying "if you want transactions" I also meant "if you want a database system that will go to great lengths to save your ass and your data instead of helping you shooting yourself in the foot, generally work very well, be reliable, friendly and a pleasure to work with, which means more or less, if you're rational rather than masochistic, then yeah, you should use postgres". > If you could force MySQL to only > use innodb tables, and to NEVER do the wrong things syntactically, it > would be ok. You'd still need to teach it how to hash-join and everything, though. Life sucks when the only join type you have is merge join.