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

From Qingqing Zhou
Subject Re: generalizing the planner knobs
Date
Msg-id dmnc17$30b9$1@news.hub.org
Whole thread Raw
In response to generalizing the planner knobs  (Neil Conway <neilc@samurai.com>)
Responses Re: generalizing the planner knobs  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
"Neil Conway" <neilc@samurai.com> wrote
>
> This would also be useful when diagnosing bad query plans: for example,
> setting enable_seqscan=false often causes the planner to disregard the
> use of *any* sequential scan, anywhere in the plan. The ability to
> slightly bump up the cost of particular operations would allow more
> alternative plans to be examined.
>

This method also has the problem of "enable_seqscan=false" in some 
situations. I would vote we implement the final general solution like query 
plan hints directly.

Regards,
Qingqing 




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [pgsql-www] Upcoming PG re-releases
Next
From: "Qingqing Zhou"
Date:
Subject: Re: [PATCHES] A couple of proposed pgbench changes