X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 0BFF1B43E26 for ; Fri, 4 Jul 2003 16:23:45 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 46764-02 for ; Fri, 4 Jul 2003 13:23:34 -0300 (ADT) Received: from ns1.gnw.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id E7AAFB43E25 for ; Fri, 4 Jul 2003 13:23:33 -0300 (ADT) Received: from ip97.85.1311c-cud12k-02.ish.de ([62.143.85.97] helo=mail.office.turtle-entertainment.de) by ns1.gnw.de with asmtp (Exim 3.22 #3 (Debian)) id 19YTLR-0003wc-00 for ; Fri, 04 Jul 2003 18:23:33 +0200 Received: from p5084b02c.dip.t-dialin.net ([80.132.176.44] helo=shock) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 19YTLP-00070v-00 for ; Fri, 04 Jul 2003 18:23:31 +0200 Message-ID: <026d01c34248$83f313d0$0564a8c0@shock> From: "Bjoern Metzdorf" To: "Postgresql Performance" References: <000301c34246$d3aadcc0$01000001@trouble> Subject: Re: PostgreSQL vs. MySQL Date: Fri, 4 Jul 2003 18:22:43 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Scanner: exiscan *19YTLP-00070v-00*58mNCHupr36* http://duncanthrax.net/exiscan/ X-Archive-Number: 200307/76 X-Sequence-Number: 2369 > I'm not saying (and never did say) that postgres could not be fast. > All I ever said was that with the same minimal effort applied to both > DBs, postgres was slower. Afaik, your original posting said postgresql was 3 times slower than mysql and that you are going to leave this list now. This implied that you have made your decision between postgresql and mysql, taking mysql because it is faster. Now you say your testing setup has minimal effort applied. Well, it is not very surprising that mysql is faster in standard configurations. As Shridhar pointed out, postgresql has very conservative default values, so that it starts on nearly every machine. If I was your client and gave you the task to choose a suitable database for my application and you evaluated suitable databases this way, then something is seriously wrong with your work. Regards, Bjoern