Re: Big disappointment with Postgres
Date: Wed, 09 Feb 2011 22:00:17 +1100
Message-ID: <iits1t$loa$1_at_news.eternal-september.org>
joel garry wrote,on my timestamp of 8/02/2011 4:28 AM:
>> Beg your pardon? So, a hint that fixes a plan "introduces upgrade and
>> maintenance issues", but a patch to fix a specific problem with the optimizer
>> does not introduce such?
>> Hellooooooo?
>
> I think the relevant problem is reliance on hints.
That's not a problem. What is a problem is over-reliance on hints. I *do* rely on hints to fix problems I cannot possibly fix otherwise. *Then* - and only then - they are simply impossible to live without.
Unless of course we are in one of the sites these bozos populate, where apparently access to the duhvelopers who wrote the app is simple and immediate.
How many of such have you been to in the last 10 years? Thought so...
> Tom Kyte's real
> feeling about hints is "See Jonathan:" http://tkyte.blogspot.com/2006/08/words-of-wisdom.htm
> I think we all knew that, but it's always fun to pick on noteworthy
> absolute statements.
But that's exactly the problem here: reliance on noteworthy absolute statements. If there is one thing I've learned in all these years is that there is no such thing as absolutes. Hence why so many folks use that (awful) expression - "it depends" - whenever someone asks any question a bit out of the "A,B,C...". One of the problems with such absolute statements is they get picked up by this kind of bozo and get used as justification for their deranged conclusions. Kinda like "we don't need no dbas", really.
> I may have missed something, but isn't the enterprisedb product
> supposed to address this?
> http://www.enterprisedb.com/docs/en/8.3/oracompat/EnterpriseDB_OraCompat_EN_8.3-92.htm#P4180_251202
Likely. Sorry, not familiar.
> I get what Mladen is saying about the developers and the racket - I'd
> even say it derives straight from the bazaar doc - I get what you are
> saying about "that lot," but I don't quite get why it doesn't count
> that a commercial solution for the exact problem exists. Fast, good,
> cheap, pick two, you know?
Very true. Received on Wed Feb 09 2011 - 05:00:17 CST