Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > I do have a longer term issue that there is no information provided by
> > EXPLAIN to allow us to differentiate these two conditions.
> Sure there is: the new startup condition affects the estimated plan
> startup cost (only) and the existing termination condition affects the
> estimated total cost (only).
Yes, but how can you tell by looking at the explain? I think the point
is that the "fraction that would be skipped" should be reported somehow.
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Criptografía: Poderosa técnica algorítmica de codificación que es
empleada en la creación de manuales de computadores.
In response to
pgsql-patches by date
|Next:||From: Simon Riggs||Date: 2007-12-07 15:14:45|
|Subject: Re: Proposed patch to make mergejoin cost estimationmore symmetric|
|Previous:||From: Tom Lane||Date: 2007-12-07 14:55:12|
|Subject: Re: Proposed patch to make mergejoin cost estimation more symmetric |