Re: generalizing the planner knobs - Mailing list pgsql-hackers

From Pollard, Mike
Subject Re: generalizing the planner knobs
Date
Msg-id 6418CC03D0FB1943A464E1FEFB3ED46B01B220F4@im01.cincom.com
Whole thread Raw
In response to generalizing the planner knobs  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Gregory Maxwell <gmaxwell@gmail.com> wrote:
> The flipside there is that a good set of hinting options  may increase
> the amount of detailed feedback we get from users on improvements
> needed in the optimizer.  The current knobs are pretty blunt and don't
> do as much as I'd like when trying to track down exactly where the
> optimiser has gone wrong.

Point conceded.  Any information that can help diagnose an issue is good
information.  I like the idea of only allowing it on explain.

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




pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Reducing relation locking overhead
Next
From: Neil Conway
Date:
Subject: Re: generalizing the planner knobs