От: Jeff Davis
Тема: Re: Hints proposal
Дата: ,
Msg-id: 1160671375.31966.84.camel@dogma.v10.wvs
(см: обсуждение, исходный текст)
Ответ на: Hints proposal  ("Jim C. Nasby")
Ответы: Re: Hints proposal  (Csaba Nagy)
Re: Hints proposal  ("Jim C. Nasby")
Список: 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 Thu, 2006-10-12 at 10:14 -0500, Jim C. Nasby wrote:
> The syntax these hints is something arbitrary. I'm borrowing Oracle's
> idea of embedding hints in comments, but we can use some other method if
> desired. Right now I'm more concerned with getting the general idea
> across.
>

Is there any advantage to having the hints in the queries? To me that's
asking for trouble with no benefit at all. It would seem to me to be
better to have a system catalog that defined hints as something like:

"If user A executes a query matching regex R, then coerce (or force) the
planner in this way."

I'm not suggesting that we do that, but it seems better then embedding
the hints in the queries themselves.

Regards,
    Jeff Davis



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

От: Jeff Davis
Дата:
Сообщение: Re: Hints proposal
От: Christopher Browne
Дата:
Сообщение: Re: Hints proposal