Re: FDW LIM IT pushdown - Mailing list pgsql-hackers

From Michał Kłeczek
Subject Re: FDW LIM IT pushdown
Date
Msg-id E86F50F3-D470-41F7-9539-4DE158FFB3AE@kleczek.org
Whole thread Raw
In response to FDW LIM IT pushdown  (Michał Kłeczek <michal@kleczek.org>)
List pgsql-hackers
Sorry, I wasn’t precise - my question is about foreign partitions - LIMIT on ordinary tables is supported.

Thanks,
Michal

> On 6 Oct 2023, at 18:02, Michał Kłeczek <michal@kleczek.org> wrote:
>
> Hello hackers,
>
> First timer here with a question:
>
> I’ve searched through various e-mail threads and documents and could not find if pushdown of LIMIT clauses to FDW is
implemented.
> Seen some conversation about that a couple of years ago when that was treated as a feature request but nothing  since
then.
> Citus does that according to its documentation but for now we are trying to base our solution on “plain” Postgres.
>
> If it is not implemented - could you, guys, provide me with some pointers to source code where I could look at and
tryto implement that? 
>
>
> Thanks,
> Michal




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: New WAL record to detect the checkpoint redo location
Next
From: Robert Haas
Date:
Subject: Re: Pre-proposal: unicode normalized text