From: Robert Treat <xzilla@users.sourceforge.net>
To: pgsql-performance@postgresql.org
Subject: Re: Hints proposal
Date: Tue, 17 Oct 2006 22:40:19 -0400
User-Agent: KMail/1.9.1
Cc: "Bucky Jordan" <bjordan@lumeta.com>,
 "Joshua Marsh" <icub3d@gmail.com>
References: <78ED28FACE63744386D68D8A9D1CF5D4209C9A@MAIL.corp.lumeta.com>
In-Reply-To: <78ED28FACE63744386D68D8A9D1CF5D4209C9A@MAIL.corp.lumeta.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200610172240.20142.xzilla@users.sourceforge.net>

On Thursday 12 October 2006 12:40, Bucky Jordan wrote:
> >What is it about hinting that makes it so easily breakable with new
> > versions?=A0 I >don't have any experience with Oracle, so I'm not sure =
how
> > they screwed logic like >this up.=A0=A0
>
> I don't have a ton of experience with oracle either, mostly DB2, MSSQL and
> PG. So, I thought I'd do some googling, and maybe others might find this
> useful info.
>
> http://asktom.oracle.com/pls/ask/f?p=3D4950:8:2177642270773127589::NO::F4=
950_
>P8_DISPLAYID,F4950_P8_CRITERIA:7038986332061
>
> Interesting quote: "In Oracle Applications development (11i apps - HR, CR=
M,
> etc) Hints are strictly forbidden.  We find the underlying cause and fix
> it." and "Hints -- only useful if you are in RBO and you want to make use
> of an access path."
>
> Maybe because I haven't had access to hints before, I've never been tempt=
ed
> to use them. However, I can't remember having to re-write SQL due to a PG
> upgrade either.
>

When it happens it tends to look something like this:
http://archives.postgresql.org/pgsql-performance/2006-01/msg00154.php

=46unny that for all the people who claim that improving the planner should=
 be=20
the primary goal that no one ever took interest in the above case. =20

=2D-=20
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL