(2019/03/01 20:16), Antonin Houska wrote:
> Etsuro Fujita<fujita.etsuro@lab.ntt.co.jp> wrote:
>> Conversely, it appears that add_foreign_ordered_paths() added by the patchset
>> would generate such pre-sorted paths *redundantly* when the input_rel is the
>> final scan/join relation. Will look into that.
>
> Currently I have no idea how to check the plan created by FDW at the
> UPPERREL_ORDERED stage, except for removing the sort from the
> UPPERREL_GROUP_AGG stage as I proposed here:
>
> https://www.postgresql.org/message-id/11807.1549564431%40localhost
I don't understand your words "how to check the plan created by FDW".
Could you elaborate on that a bit more?
Best regards,
Etsuro Fujita