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 D1FE19DC846 for ; Tue, 13 Dec 2005 06:14:04 -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 77605-02 for ; Tue, 13 Dec 2005 06:13:51 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by postgresql.org (Postfix) with ESMTP id E2F819DC81F for ; Tue, 13 Dec 2005 06:13:42 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so717154nzn for ; Tue, 13 Dec 2005 02:13:45 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Oc2zbLH95y6xJSkU+SIpx5buY7rAyBibL5bR+FTjJJQxN6Eeqq8kdrNjtNKmkrpUqRUkkHdB9K4A/G6vQhpl7fch1yvWYZsXDYQqkeu8JsnhVzBQE01nch3De2Ynkl3BhG6YBNCq50tmA/HH0nguQRzwdnpRmYl4N0ysdictyEM= Received: by 10.65.252.5 with SMTP id e5mr448198qbs; Tue, 13 Dec 2005 02:13:45 -0800 (PST) Received: by 10.65.224.16 with HTTP; Tue, 13 Dec 2005 02:13:45 -0800 (PST) Message-ID: Date: Tue, 13 Dec 2005 10:13:45 +0000 From: Neil Saunders To: "Pedro B." Subject: Re: Why is PGSQL better than MySQL Cc: John Mohr , pgsql-php@postgresql.org In-Reply-To: <1134440689.25330.112.camel@localhost> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1134440689.25330.112.camel@localhost> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200512/17 X-Sequence-Number: 3363 Agreed. You can't argue with a well executed benchmark. All I'd say is be careful not just the same simple select statement over and over again - Do a variety of both simple and complex queries. And always use InnoDB as compared to MyISAM (otherwise you're not comparing apples with apples). The biggest pro (imho) that PostgreSQL has over MySQL is its locking mechanism. PostgreSQL uses MVCC, which greatly improves concurrency. For a list of "Gotchas" take a look at these: http://sql-info.de/mysql/gotchas.html http://sql-info.de/postgresql/postgres-gotchas.html Also stumbled across this: http://www.vitavoom.com/postgresql.html On 12/13/05, Pedro B. wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >