Re: [PERFORM] Hints proposal

From: "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PERFORM] Hints proposal
Date: 2006-10-13 15:04:18
Message-ID: E1539E0ED7043848906A8FF995BDA579016A0ADC@m0143.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance


> > 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.

This is not an example. For us to understand, we need an actual case
with syntax and all, and what happened.

Imho the use of a stupid hint, that was added without analyzing
the cause and background of the problem is no proof that statement hints
are bad,
only that the person involved was not doing his job.

Andreas

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew - Supernews 2006-10-13 15:13:29 Re: more anti-postgresql FUD
Previous Message Alexander Staubo 2006-10-13 15:02:55 Re: more anti-postgresql FUD

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-13 16:16:14 Re: [HACKERS] Hints proposal
Previous Message Csaba Nagy 2006-10-13 14:20:08 Re: [PERFORM] Hints proposal