Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 557C9133798E
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  4 Feb 2011 09:56:39 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 29434-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  4 Feb 2011 13:56:32 +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.125])
	by mail.postgresql.org (Postfix) with ESMTP id 1EACE1336FA7
	for <pgsql-performance@postgresql.org>;
	Fri,  4 Feb 2011 09:56:31 -0400 (AST)
X-Authority-Analysis: v=1.1 cv=3uSaImBeuprzHBlOOPjkqgu+7PcxSRW0m2Aphm9Zmck=
	c=1 sm=0 a=iCf4CIWKqigA:10 a=JRZeEW2aRuwA:10 a=nDOwLv4DKMQA:10
	a=RAii6je2cdnAH6ATCOpc6g==:17 a=_Ixf_7qHAAAA:8
	a=hwOL9MIhtd-WN3F0K0YA:9 a=HrfYd4Ac9SQVuthsEbL-YX2IAdQA: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:52615] helo=[192.168.1.100])
	by hrndva-oedge04.mail.rr.com (envelope-from
	<mladen.gogala@vmsinfo.com>) (ecelerity 2.2.3.46 r()) with ESMTP
	id 53/F7-04612-0950C4D4; Fri, 04 Feb 2011 13:56:32 +0000
Message-ID: <4D4C0590.1050609@vmsinfo.com>
Date: Fri, 04 Feb 2011 08:56:32 -0500
From: Mladen Gogala <mladen.gogala@vmsinfo.com>
Reply-To: mladen.gogala@vmsinfo.com
Organization: VMS
User-Agent: Thunderbird 2.0.0.24 (X11/20101213)
MIME-Version: 1.0
To: =?KOI8-U?Q?=F7=A6=D4=C1=CC=A6=CA_=F4=C9=CD=DE=C9=DB=C9=CE?=
	<tivv00@gmail.com>, pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Talking about optimizer, my long dream
References: <AANLkTikMbdPKq_pgihiUOWRnR3eSsn0B1vjMKonq1QrL@mail.gmail.com>
In-Reply-To: <AANLkTikMbdPKq_pgihiUOWRnR3eSsn0B1vjMKonq1QrL@mail.gmail.com>
Content-Type: text/plain; charset=KOI8-U; format=flowed
Content-Transfer-Encoding: 8bit
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/180
X-Sequence-Number: 42318

÷¦ÔÁÌ¦Ê ôÉÍÞÉÛÉÎ wrote:
> Hi, all.
>
> All this optimizer vs hint thread
There is no "optimizer vs. hint". 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 was willing to wait but 
the fatwa against hints seems unyielding, so that's it. I am even 
inclined to believe that deep down under the hood, this fatwa has an 
ulterior motive, which disgusts me deeply. With hints, there would be 
far fewer consulting gigs.

Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com