May 2018
Intermediate to advanced
576 pages
30h 25m
English
PostgreSQL provides the infrastructure for collecting statistics on foreign tables, so the planner will be able to consider such information, provided that the feature is implemented in the specific Foreign Data Wrapper you are using. For example, statistics are supported by oracle_fdw.
The latest improvements for foreign tables include trigger support, IMPORT FOREIGN SCHEMA, and several improvements to the query planner.
Particularly useful for database administrators is the IMPORT FOREIGN SCHEMA syntax, which can be used to create, with a single statement, foreign tables for all tables and views in a given remote schema.
Among the query planner improvements, we wish to mention Join Pushdown. In a nutshell: a query that joins ...