Foreign Data Wrapper behavior?

From: Koen De Groote <kdg(dot)dev(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Foreign Data Wrapper behavior?
Date: 2024-10-11 11:08:28
Message-ID: CAGbX52Eqa25L1afuVq6NWfnMfmwV5m5zpek=whU8=5U-E9unxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the release notes for postgres 17 I'm reading:

> The PostgreSQL foreign data wrapper (postgres_fdw), used to execute
queries on remote PostgreSQL instances, can now push EXISTS and IN
subqueries to the remote server for more efficient processing.

I'm confused as to what this means. In older versions, are parts of queries
not sent to the foreign server? Or is this change meant to imply the
sending of only the subqueries, the result of which is then directly used
in pushing the entire query?

Or am I still wrong as to what this means?

I looked at the documentation and there doesn't seem to be any indication
of particular queries not being pushed to the foreign server, so this
wording that "can now push EXISTS and IN subqueries to the remote server"
is confusing.

What am I missing?

Regards,
Koen De Groote

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-10-11 11:29:15 Re: Question on indexes
Previous Message Thürmann 2024-10-11 08:23:20 Connection between PostgreSQL and SAP HANA database