Re: Multi-pass planner - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Multi-pass planner
Date
Msg-id m2ip42qg9t.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Multi-pass planner  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Multi-pass planner
Re: Multi-pass planner
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> for estimate_worstcase_fraction.  So, when computing the cost of a
> path, we'd compute our current expected-case estimate, and also a
> worst-case estimate, and then compute the final cost as:

There also was the idea for the executor to be able to handle alternate
plans and some heuristic to determine that the actual cost of running a
plan is much higher than what's been estimated, so much so as to switch
to starting from scratch with the other plan instead.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Hash Join cost estimates
Next
From: Stephen Frost
Date:
Subject: Re: Hash Join cost estimates