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
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 |