Skip site navigation (1) Skip section navigation (2)

Re: generalizing the planner knobs

From: "Pollard, Mike" <mpollard(at)cincom(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Greg Stark" <gsstark(at)mit(dot)edu>
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>,"Neil Conway" <neilc(at)samurai(dot)com>,"pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: generalizing the planner knobs
Date: 2005-12-01 21:14:11
Message-ID: 6418CC03D0FB1943A464E1FEFB3ED46B01B220F2@im01.cincom.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Stark <gsstark(at)mit(dot)edu> writes:
> On the other hand the type I would prefer to see are hints that feed
directly
> into filling in information the planner lacks. This only requires that
the
> user understand his own data and still lets the planner pick the best
plan
> based on the provided information.

Optimizer hints were added because some databases just don't have a very
smart optimizer.  But you are much better served tracking down cases in
which the optimizer makes a bad choice, and teaching the optimizer how
to make a better one.  That way, all users get the benefit of the fix.
Remember, the purpose of SQL is to isolate the end user from having to
care about how the data is retrieved; that is the RDBMS' problem.  (the
other thing forgotten was that it was supposed to be a natural language.
NVL.  Bah.)

Mike Pollard
SUPRA Server SQL Engineering and Support
Cincom Systems, Inc.



Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2005-12-01 21:20:51
Subject: Re: [COMMITTERS] pgsql: Add comments about why errno is set to zero.
Previous:From: Bruce MomjianDate: 2005-12-01 21:12:30
Subject: Re: [COMMITTERS] pgsql: Add comments about why errno is set to zero.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group