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 1B3B1B439CA for ; Fri, 4 Jul 2003 22:25:17 +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 40586-03 for ; Fri, 4 Jul 2003 19:25:06 -0300 (ADT) Received: from ns1.gnw.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id B1258B43168 for ; Fri, 4 Jul 2003 19:25:05 -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 19YYzE-0008Az-00; Sat, 05 Jul 2003 00:25:00 +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 19YYzB-0001iB-00; Sat, 05 Jul 2003 00:24:58 +0200 Message-ID: <032f01c3427b$031479b0$0564a8c0@shock> From: "Bjoern Metzdorf" To: "Brian Tarbox" , "Postgresql Performance" References: <002301c34271$30afc870$01000001@trouble> Subject: Re: PostgreSQL vs. MySQL Date: Sat, 5 Jul 2003 00:24:18 +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 *19YYzB-0001iB-00*.dHzQKoPUNE* http://duncanthrax.net/exiscan/ X-Archive-Number: 200307/97 X-Sequence-Number: 2390 >> 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. > > Well, that shows what you get for making implications. The client is > sticking with postgres and we are coding around the issue in other > ways. As many other guys here pointed out, there are numerous ways to tune postgresql for maximum performance. If you are willing to share more information about your particular project, we might be able to help you out and optimize your application, without the need to code around the issue as much as you may be doing right now. Even if it is not possible for you to share enough information, there are a lot of places where you can read about performance tuning (if not in the docs then in the archives). >> 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. >> > Glad to see you're not getting personal with this. Ad hominin attacks > are for folks with no better answers. Yep, you're right. Sorry for that, I didn't mean to get personal. I was somehow irritated that you come here, post your database comparison and want to leave right afterwards, without going into detail (what should be the case normally). Again our offer: Post (possibly obfuscated) schema information, and we will certainly be able to help you with performance tuning. Regards, Bjoern