X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BB4C28BA184 for ; Fri, 11 Feb 2005 18:29:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16018-04 for ; Fri, 11 Feb 2005 18:29:12 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id B89848BA138 for ; Fri, 11 Feb 2005 18:29:12 +0000 (GMT) Received: (qmail 31049 invoked from network); 11 Feb 2005 19:29:41 +0100 Received: from unknown (HELO musicbox) (boutiquenumerique-lists@192.168.0.2) by boutiquenumerique.com with SMTP; 11 Feb 2005 19:29:41 +0100 To: "performance pgsql" Subject: Re: Benchmark References: <20050210054910.76921.qmail@web50005.mail.yahoo.com> <330532b60502102122638d887@mail.gmail.com> <7414.1108103893@sss.pgh.pa.us> <330532b605021023043b34e03@mail.gmail.com> <873bw387fb.fsf@stark.xeocode.com> Message-ID: Date: Fri, 11 Feb 2005 19:32:40 +0100 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <873bw387fb.fsf@stark.xeocode.com> User-Agent: Opera M2/7.54u1 (Linux, build 892) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/190 X-Sequence-Number: 10519 > In terms of performance, Oracle is to Postgres as Postgres is to Mysql: > More > complexity, more overhead, more layers of abstraction, but in the long > run it > pays off when you need it. (Only without the user-friendliness of either > open-source softwares.) > I don't find postgres complex... I find it nice, well-behaved, very easy to use, very powerful, user-friendly... there are a lot of features but somehow it's well integrated and makes a coherent set. It also has some very useful secret passages (like the whole GiST family) which can save you from some things at which SQL really sucks. It certainly is complex on the inside but I think the devs have done a very good job at hiding that. It's also polite : it will say 'I have a function with the name you said but the parameter types don't match' ; mysql will just say 'syntax error, RTFM', or insert its favorite value of 0.