Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Hints proposal
- From: Jeff Davis <pgsql(at)j-davis(dot)com>
- To: "Jim C. Nasby" <jim(at)nasby(dot)net>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Hints proposal
- Date: Thu, 12 Oct 2006 09:42:55 -0700
- Message-id: <1160671375(dot)31966(dot)84(dot)camel(at)dogma(dot)v10(dot)wvs>
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
- Follow-Ups:
- Re: Hints proposal
- From: Jim C. Nasby
- Re: Hints proposal
- From: Csaba Nagy
- Re: Hints proposal
- References:
- Hints proposal
- From: Jim C. Nasby
- Hints proposal
- Prev by Date: Re: [HACKERS] Hints proposal
- Next by Date: Re: [HACKERS] Hints proposal
- Previous by thread: Re: [HACKERS] Hints proposal
- Next by thread: Re: Hints proposal
- Indexes: