Re: FDW LIM IT pushdown

From: Michał Kłeczek <michal(at)kleczek(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: FDW LIM IT pushdown
Date: 2023-10-06 17:55:08
Message-ID: E86F50F3-D470-41F7-9539-4DE158FFB3AE@kleczek.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)kleczek(dot)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 try to implement that?
>
>
> Thanks,
> Michal

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2023-10-06 18:17:32 Re: Pre-proposal: unicode normalized text
Previous Message Robert Haas 2023-10-06 17:44:55 Re: New WAL record to detect the checkpoint redo location