Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id DF6D01337B95 for ; Fri, 4 Feb 2011 10:36:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 92731-04 for ; Fri, 4 Feb 2011 14:36:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hrndva-omtalb.mail.rr.com (hrndva-omtalb.mail.rr.com [71.74.56.123]) by mail.postgresql.org (Postfix) with ESMTP id 4323A133740B for ; Fri, 4 Feb 2011 10:36:10 -0400 (AST) X-Authority-Analysis: v=1.1 cv=dquaJDitHqzHCdqWSoZ6IgapSuTzW/4TaRYx9N9k4W8= c=1 sm=0 a=iCf4CIWKqigA:10 a=JRZeEW2aRuwA:10 a=nDOwLv4DKMQA:10 a=RAii6je2cdnAH6ATCOpc6g==:17 a=_Ixf_7qHAAAA:8 a=4FHJNPbhvoisiy20F9kA:9 a=nyEjZD8NTgE69WGPGBeDRW_cIWUA:4 a=sOKxrc_Uve4A:10 a=ryAo9hy1-OkA:10 a=6vsjEBoLwlAA:10 a=0tfO7MgyNwYA:10 a=RAii6je2cdnAH6ATCOpc6g==:117 X-Cloudmark-Score: 0 X-Originating-IP: 74.73.87.196 Received: from [74.73.87.196] ([74.73.87.196:18555] helo=[192.168.1.100]) by hrndva-oedge01.mail.rr.com (envelope-from ) (ecelerity 2.2.3.46 r()) with ESMTP id 36/1C-14011-BDE0C4D4; Fri, 04 Feb 2011 14:36:11 +0000 Message-ID: <4D4C0EDA.8000704@vmsinfo.com> Date: Fri, 04 Feb 2011 09:36:10 -0500 From: Mladen Gogala Reply-To: mladen.gogala@vmsinfo.com Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101213) MIME-Version: 1.0 To: "sthomas@peak6.com" CC: =?KOI8-U?Q?=F7=A6=D4=C1=CC=A6=CA_=F4=C9=CD=DE=C9=DB=C9=CE?= , pgsql-performance Subject: Re: Talking about optimizer, my long dream References: <4D4C0590.1050609@vmsinfo.com> <4D4C0702.1040909@peak6.com> In-Reply-To: <4D4C0702.1040909@peak6.com> Content-Type: text/plain; charset=KOI8-U; format=flowed Content-Transfer-Encoding: 7bit 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/184 X-Sequence-Number: 42322 Shaun Thomas wrote: > On 02/04/2011 07:56 AM, Mladen Gogala wrote: > > >> Hints are a necessary part of the >> optimizer in all other databases. Without hints Postgres will not get >> used in the company that I work for, period. >> > > I've said repeatedly that EnterpriseDB, a fork of PostgreSQL, has the > hints you seek, yet you seem to enjoy berating the PostgreSQL community > as if it owes you something. > > Also, we don't care if you don't use PostgreSQL. If I put something up > for free, some random guy not taking it won't exactly hurt my feelings. > > Shaun, I don't need to convince you or the Postgres community. I needed an argument to convince my boss. My argument was that the sanctimonious and narrow minded Postgres community is unwilling to even consider creating the tools I need for large porting projects, tools provided by other major databases. This discussion served my purpose wonderfully. Project is killed, here we part ways. No more problems for either of us. Good luck with the "perfect optimizer" and good riddance. My only regret is about the time I have wasted. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com