Re: Plan stability versus near-exact ties in cost estimates - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: Plan stability versus near-exact ties in cost estimates
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2049FCE82@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Plan stability versus near-exact ties in cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
>>> Um, that is what the proposed patch does.

>> I was referring to the first two lines that the patch removes.
>> I guess I don't understand why they should go.

> What we'd have left after the proposed removal is
>
>                            if (new_path->rows < old_path->rows)
>                                  remove_old = true;  /* new dominates old */
>                            else
>                                  accept_new = false; /* old equals or dominates new */
>
> There's no need to make more than one test on the rows values.

I see, thanks for explaining.

Yours,
Laurenz Albe


pgsql-hackers by date:

Previous
From: Qi Huang
Date:
Subject: Re: Gsoc2012 idea, tablesample
Next
From: Guillaume Lelarge
Date:
Subject: Re: RANGE type, and its subtype parameter