Re: Considering fractional paths in Append node - Mailing list pgsql-hackers

From Andy Fan
Subject Re: Considering fractional paths in Append node
Date
Msg-id 87cyjx2c2a.fsf@163.com
Whole thread Raw
In response to Considering fractional paths in Append node  (Nikita Malakhov <hukutoc@gmail.com>)
Responses Re: Considering fractional paths in Append node
List pgsql-hackers
Nikita Malakhov <hukutoc@gmail.com> writes:

Hi Nikita,

> Hi!
>
> Andy, one quick question - what do you think on using
> root->limit_tuples as a guidance on how many 
> rows we have to consider in plans cost?

Within my exprerience, the committer probabaly dislikes the idea of
"ignoring  the difference of tuple_fraction between subquery level and
RelOptInfo level" and the committers dislikes a complex soluation like
what I did in [1]. Maybe you can try to figure out completed and simple
soluation to make everyone happy, but I have no idea about on this right
now. 

[1]
https://www.postgresql.org/message-id/CAApHDvry0nSV62kAOH3iccvfPhGPLN0Q97%2B%3Db1RsDPXDz3%3DCiQ%40mail.gmail.com

-- 
Best Regards
Andy Fan




pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: Statistics Import and Export
Next
From: Andrei Lepikhov
Date:
Subject: Re: allowing extensions to control planner behavior