On Wed, Nov 1, 2017 at 8:41 PM, Tom Lane wrote:
> Ashutosh Bapat writes:
>> On Wed, Nov 1, 2017 at 3:15 AM, Tom Lane wrote:
>>> here's a patch to fix the planner so that eval costs and selectivity of
>>> HAVING quals are
Ashutosh Bapat writes:
> On Wed, Nov 1, 2017 at 3:15 AM, Tom Lane wrote:
>> here's a patch to fix the planner so that eval costs and selectivity of
>> HAVING quals are factored into the appropriate plan node numbers.
>> ...
>> + /* Add
On Wed, Nov 1, 2017 at 3:15 AM, Tom Lane wrote:
> Pursuant to the discussion at
> https://www.postgresql.org/message-id/20171029112420.8920b5f...@mx.zeyos.com
> here's a patch to fix the planner so that eval costs and selectivity of
> HAVING quals are factored into the
Hello David,
On Tue, October 31, 2017 7:54 pm, David G. Johnston wrote:
> On Tue, Oct 31, 2017 at 4:31 PM, Tels
> wrote:
>
>>
>>
>> That looks odd to me, it first uses output_tuples in a formula, then
>> overwrites the value with a new value. Should these lines
"David G. Johnston" writes:
> On Tue, Oct 31, 2017 at 4:31 PM, Tels wrote:
>> That looks odd to me, it first uses output_tuples in a formula, then
>> overwrites the value with a new value. Should these lines be swapped?
> IIUC it is
On Tue, Oct 31, 2017 at 4:31 PM, Tels wrote:
>
>
> That looks odd to me, it first uses output_tuples in a formula, then
> overwrites the value with a new value. Should these lines be swapped?
>
IIUC it is correct: the additional total_cost comes from
Moin,
On Tue, October 31, 2017 5:45 pm, Tom Lane wrote:
> Pursuant to the discussion at
> https://www.postgresql.org/message-id/20171029112420.8920b5f...@mx.zeyos.com
> here's a patch to fix the planner so that eval costs and selectivity of
> HAVING quals are factored into the appropriate plan
Pursuant to the discussion at
https://www.postgresql.org/message-id/20171029112420.8920b5f...@mx.zeyos.com
here's a patch to fix the planner so that eval costs and selectivity of
HAVING quals are factored into the appropriate plan node numbers.
Perhaps unsurprisingly, this doesn't change the