Message-ID: <4D4C8F53.8090804@catalyst.net.nz>
Date: Sat, 05 Feb 2011 12:44:19 +1300
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.13) Gecko/20101208 Thunderbird/3.1.7
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Talking about optimizer, my long dream
References: <AANLkTikMbdPKq_pgihiUOWRnR3eSsn0B1vjMKonq1QrL@mail.gmail.com>
	<4D4C0590.1050609@vmsinfo.com> <4D4C0702.1040909@peak6.com>
	<4D4C0EDA.8000704@vmsinfo.com>
In-Reply-To: <4D4C0EDA.8000704@vmsinfo.com>
Content-Type: text/plain; charset=KOI8-U; format=flowed
Content-Transfer-Encoding: 7bit

On 05/02/11 03:36, Mladen Gogala wrote:
> 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.
>

I think it is unlikely that your boss is going to dismiss Postgres on 
the basis of some minor technical point (no optimizer hints). Bosses 
usually (and should) care about stuff like reference sites, product 
pedigree and product usage in similar sized companies to theirs. 
Postgres will come out rather well if such an assessment is actually 
performed I would think.

The real question you should be asking is this:

Given that there are no hints, what do I do to solve the problem of a 
slow query suddenly popping up in production? If and when this situation 
occurs, see how quickly the community steps in to help you solve it (and 
it'd bet it will solved be very quickly indeed).

Best wishes

Mark