Re: Big disappointment with Postgres
Date: Wed, 09 Feb 2011 08:54:59 -0500
Message-ID: <aq65l651ciueqe3pjen7s5nat9pa4u7jo6_at_4ax.com>
On Wed, 09 Feb 2011 22:06:19 +1100, Noons <wizofoz2k_at_yahoo.com.au> wrote:
>ddf wrote,on my timestamp of 8/02/2011 1:15 AM:
>
>>
>> And I agree but many DBAs don't have the luxury of tuning queries
>> before they get to production as the companies they work for use
>> canned apps where the code cannot be touched. Hints and outlines can
>> save the day in such situations.
>
>"many"? Where I live, it's almost all of them. Hence why generalizations of
>the kind "dbas like hints because they lock-in" are completely out of kilter and
>void of any context or value.
>
>> Not for prepackaged code that is 'untouchable'. Or don't you have to
>> administer systems like Portal?
>
>Yeah. But for example, execution profiles and such are simply impossible
>without some hint mechanism. These luminaries have basically brain-damaged
>Postgres for large production environments because they didn't ask any
>experienced production dba how to handle third party apps and what typical
>problems they see.
>
>But of course we know they are all geniuses and any field experience for them is
>flawed by "dba attitudes". And other such lunacy. Typical Stonebraker attitude.
I keep having flashbacks to the no outer joins no nulls ever Ingres days. Received on Wed Feb 09 2011 - 07:54:59 CST