Re: ORDER BY pushdowns seem broken in postgres_fdw - Mailing list pgsql-hackers

From David Rowley
Subject Re: ORDER BY pushdowns seem broken in postgres_fdw
Date
Msg-id CAApHDvr1xyFoiVOMx0e4QDQjeuSWpbG9DNPLKx2Ur_uuuSNAQg@mail.gmail.com
Whole thread Raw
In response to Re: ORDER BY pushdowns seem broken in postgres_fdw  (Ronan Dunklau <ronan.dunklau@aiven.io>)
Responses Re: ORDER BY pushdowns seem broken in postgres_fdw  (David Zhang <david.zhang@highgo.ca>)
List pgsql-hackers
On Tue, 27 Jul 2021 at 17:20, Ronan Dunklau <ronan.dunklau@aiven.io> wrote:
> One thing in particular I was not sure about was how to fetch the operator
> associated with the path key ordering. I chose to go through the opfamily
> recorded on the member, but maybe locating the original SortGroupClause by its
> ref and getting the operator number here woud have worked. It seems more
> straightforward like this though.

I spent a bit of time trying to find a less invasive way of doing that
and didn't manage to come up with anything. I'm interested to hear if
anyone else has any better ideas.

David



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: ATTACH PARTITION locking documentation for DEFAULT partitions
Next
From: Bharath Rupireddy
Date:
Subject: Re: Inaccurate error message when set fdw batch_size to 0