От: Robert Treat
Тема: Re: Hints proposal
Дата: ,
Msg-id: 200610172240.20142.xzilla@users.sourceforge.net
(см: обсуждение, исходный текст)
Ответ на: Re: Hints proposal  ("Bucky Jordan")
Ответы: Re: Hints proposal  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

Hints proposal  ("Jim C. Nasby", )
 Re: Hints proposal  (Bruce Momjian, )
  Re: Hints proposal  (Heikki Linnakangas, )
   Re: Hints proposal  (Tom Lane, )
   Re: Hints proposal  ("Jim C. Nasby", )
 Re: Hints proposal  ("Joshua Marsh", )
  Re: Hints proposal  ("Bucky Jordan", )
   Re: Hints proposal  (Robert Treat, )
    Re: Hints proposal  (Tom Lane, )
     Re: Hints proposal  (Robert Treat, )
  Re: Hints proposal  ("Jim C. Nasby", )
 Re: Hints proposal  (Tom Lane, )
  Re: Hints proposal  ("Merlin Moncure", )
  Re: [HACKERS] Hints proposal  ("Jim C. Nasby", )
   Re: [HACKERS] Hints proposal  (Josh Berkus, )
    Re: [HACKERS] Hints proposal  ("Jim C. Nasby", )
     Re: [HACKERS] Hints proposal  (Josh Berkus, )
      Re: [HACKERS] Hints proposal  ("Bucky Jordan", )
       Re: [HACKERS] Hints proposal  (Alvaro Herrera, )
      Re: [HACKERS] Hints proposal  ("Jim C. Nasby", )
       Re: [HACKERS] Hints proposal  (Tom Lane, )
       Re: [HACKERS] Hints proposal  ("Bucky Jordan", )
        Re: Hints proposal  ("Craig A. James", )
         Re: Hints proposal  (, )
         Re: Hints proposal  (Mark Kirkwood, )
          Re: Hints proposal  (Csaba Nagy, )
           Re: Hints proposal  (Brian Hurt, )
            Re: Hints proposal  (Bruce Momjian, )
            Re: Hints proposal  (Shaun Thomas, )
           Re: Hints proposal  (Mark Kirkwood, )
       Re: [HACKERS] Hints proposal  (Josh Berkus, )
        Re: [HACKERS] Hints proposal  ("Jim C. Nasby", )
         Re: [HACKERS] Hints proposal  (Alvaro Herrera, )
         Re: [HACKERS] Hints proposal  (Tom Lane, )
      Re: [HACKERS] Hints proposal  (Gregory Stark, )
    Re: Hints proposal  ("Craig A. James", )
    Re: [HACKERS] Hints proposal  ("Zeugswetter Andreas ADI SD", )
  Re: Hints proposal  (Csaba Nagy, )
   Re: [HACKERS] Hints proposal  (Josh Berkus, )
    Re: [HACKERS] Hints proposal  (Csaba Nagy, )
   Re: [HACKERS] Hints proposal  (Tom Lane, )
 Re: Hints proposal  (Jeff Davis, )
  Re: Hints proposal  (Csaba Nagy, )
   Re: Hints proposal  (Jeff Davis, )
    Re: Hints proposal  (Arjen van der Meijden, )
     Re: Hints proposal  (Tom Lane, )
      Re: Hints proposal  (Jeff Davis, )
     Re: Hints proposal  (Richard Broersma Jr, )
     Re: Hints proposal  (Christopher Browne, )
  Re: Hints proposal  ("Jim C. Nasby", )
   Re: Hints proposal  (Jeff Davis, )
 Re: [HACKERS] Hints proposal  (Andrew Sullivan, )
 Re: [HACKERS] Hints proposal  (Robert Treat, )

On Thursday 12 October 2006 12:40, Bucky Jordan wrote:
> >What is it about hinting that makes it so easily breakable with new
> > versions?  I >don't have any experience with Oracle, so I'm not sure how
> > they screwed logic like >this up.  
>
> 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=4950:8:2177642270773127589::NO::F4950_
>P8_DISPLAYID,F4950_P8_CRITERIA:7038986332061
>
> Interesting quote: "In Oracle Applications development (11i apps - HR, CRM,
> 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 tempted
> 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

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

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL


В списке pgsql-performance по дате сообщения:

От: Ruben Rubio
Дата:
Сообщение: Re: Optimization of this SQL sentence
От: Mario Weilguni
Дата:
Сообщение: Re: Optimization of this SQL sentence