Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id CEA641337B68 for ; Thu, 3 Feb 2011 02:17:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 03249-07 for ; Thu, 3 Feb 2011 06:17:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 679461336FA7 for ; Thu, 3 Feb 2011 02:17:22 -0400 (AST) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis) id 0Ls7Sx-1QA0IU3Rhn-013vak; Thu, 03 Feb 2011 07:16:39 +0100 Message-ID: <4D4A4844.3020409@2ndquadrant.com> Date: Thu, 03 Feb 2011 01:16:36 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Mladen Gogala CC: Robert Haas , Andrew Dunstan , Bruce Momjian , Tom Lane , "david@lang.hm" , Craig Ringer , Vitalii Tymchyshyn , "pgsql-performance@postgresql.org" Subject: Re: [HACKERS] Slow count(*) again... References: <201102012247.p11Ml6u02682@momjian.us> <4D48914B.4050403@dunslane.net> <4D489AD1.1010105@vmsinfo.com> <4D499E55.4020107@vmsinfo.com> <4D49A6B9.4060608@2ndquadrant.com> <4D49C482.4010707@vmsinfo.com> <4D49F0BA.9000901@2ndquadrant.com> <4D4A16BF.1020304@vmsinfo.com> In-Reply-To: <4D4A16BF.1020304@vmsinfo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:F7pDNG7Skg3Lr9HeelXYZLcpdjqWhYcp3uqRacga4cd iQcSg0v9QiOQnZn6ZKE8pDtc+0Iyo1Tlvh0aOhOSz38UTsixwK MgvXbI9UuM6i4xIhVjmcPXUKt/QBGM/S5z+/fO8GeVka2eE/L2 Xy8m3GZ7R4Bvcdv3PBgML0haVQkG5YtS+E2GunpP5SqvQCI+Kv 2/o4hOa2jB+iT9XYiydbIonrDW2B0jUi81/lSdcvEc= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201102/63 X-Sequence-Number: 42201 Mladen Gogala wrote: > The techies at big companies are the guys who will or will not make it > happen. And these guys are not beginners. Appeasing them may actually > go a long way. The PostgreSQL community isn't real big on appeasing people if it's at the expense of robustness or correctness, and this issue falls into that category. There are downsides to that, but good things too. Chasing after whatever made people happy regardless of its impact on the server code itself has in my mind contributed to why Oracle is so bloated and MySQL so buggy, to pick two examples from my favorite horse to whip. Trying to graft an alternate UI for the stuff that needs to be tweaked here to do better, one flexible enough to actually handle the complexity of the job, is going to add some code with a new class of bugs and continous maintenance headaches. Being picky about rejecting such things is part of the reason why the PostgreSQL code has developed a good reputation. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books