X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 588359DCC30 for ; Mon, 12 Dec 2005 22:24:51 -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 83645-03 for ; Mon, 12 Dec 2005 22:24:55 -0400 (AST) X-Greylist: delayed 08:23:22.788102 by SQLgrey- Received: from exch01smtp10.hdi.tvcabo (smtp1.netcabo.pt [212.113.174.28]) by postgresql.org (Postfix) with ESMTP id 1C96F9DCC03 for ; Mon, 12 Dec 2005 22:24:48 -0400 (AST) Received: from m3ta ([85.138.142.221] RDNS failed) by exch01smtp10.hdi.tvcabo with Microsoft SMTPSVC(6.0.3790.211); Tue, 13 Dec 2005 02:24:52 +0000 Subject: Re: Why is PGSQL better than MySQL From: "Pedro B." To: John Mohr Cc: pgsql-php@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Tue, 13 Dec 2005 02:24:48 +0000 Message-Id: <1134440689.25330.112.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.5.2 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 13 Dec 2005 02:24:52.0909 (UTC) FILETIME=[6670A5D0:01C5FF8C] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.439 required=5 tests=[AWL=-0.480, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.439 X-Spam-Level: * X-Archive-Number: 200512/16 X-Sequence-Number: 3362 On Mon, 2005-12-12 at 20:02 -0600, John Mohr wrote: > But does anyone know if there is a quasi-categorical comparison of the > two so that I could speak with more conviction other than "I know it's > better". I've been involved in that comparison at work, and after some boring theoretical discussions, i once turned to my CTO and said: "Do a test. On the same machine, do a script that executes 50.000 inserts, OR any other 50.000 SQL operations you want, and benchmark the results". He did, and Postgres immediately got another die-hard fan. The facts spoke more clearly than i could ever do, with just words. Nowadays, he is even more "defensive" of PGSQL over MySQL than i am. \\pb