On Fri, Oct 13, 2006 at 10:41:36AM +0200, Zeugswetter Andreas ADI SD wrote: > Can you give us an example that had such a monstrous effect in Oracle, > other than that the hint was a mistake in the first place ?
Of course the hint was a mistake in the first place; the little story I told was exactly an example of such a case. The hint shouldn't have been put in place at the beginning; instead, the root cause should have been uncovered. It was not, the DBA added a hint, and later that hint turned out to have unfortunate consequences for some other use case. And it's a long-term monstrosity, remember, not a short one: the problem is in maintenance overall. This is a particularly sensitive area for PostgreSQL, because the planner has been making giant leaps forward with every release. Indeed, as Oracle's planner got better, the hints people had in place sometimes started to cause them to have to re-tune everything. My Oracle-using acquaintances tell me this has gotten better in recent releases; but in the last two days, one person pointed out that hints are increasingly relied on by one part of Oracle, even as another Oracle application insists that they never be used. That's exactly the sort of disagreement I'd expect to see when people have come to rely on what is basically a kludge in the first place. And remember, the places where PostgreSQL is getting used most heavily are still the sort of environments where people will take a lot of short cuts to achieve an immediate result, and be annoyed when that short cut later turns out to have been expensive. Postgres will get a black eye from that ("Too hard to manage! Upgrades cause all sorts of breakage!"). A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly