On Sun, Oct 8, 2023 at 5:04 AM Michał Kłeczek <michal(at)kleczek(dot)org> wrote:
> Hi All,
>
> Attached is a second version of the patch.
>
> The goal is to:
> 1. Apply LIMIT as early as possible - especially to apply LIMIT in
> partition scans
>
For the patches for performance improvement, it is better to provide
an example to show how much benefits we can get. As for this case,
I'm doubtful it can work as an improvement.
2. Enable LIMIT pushdown for FDW partitions.
>
The same as above, some testing is helpful.
--
Best Regards
Andy Fan