Postgres Pro
Downloads
Home   >   mailing lists

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

From Nikita Malakhov
Subject Re: Considering fractional paths in Append node
Date
Msg-id CAN-LCVPCS4nhQARySFcQHhUQdxZHagWXmxr=SMekgDAxU5124A@mail.gmail.com
Whole thread Raw
In response to Re: Considering fractional paths in Append node  (Andrei Lepikhov <lepihov@gmail.com>)
List pgsql-hackers
Tree view
Hi,

Andy, your words make sense, but to me it seems that in add_paths_to_append_rel
we have no other options than tuple_fraction from root, and rows (if any) in paths
we take into account, please correct me if I am wrong.

Thank you!

Also, on top of that I have an idea of pruning unnecessary partitions
in generate_orderedappend_paths() when we have a valid LIMIT value.
I'm currently checking if it is working correctly in multiple cases,
so 'll send it after we deal with this issue.

--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Pgoutput not capturing the generated columns
Next
From: "Joel Jacobson"
Date:
Subject: Re: New "raw" COPY format