- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 64字
- 2021-07-09 19:57:11
Using more advanced foreign data wrappers
Foreign data wrappers have been around for many years. Starting with PostgreSQL 9.6, the optimizer can use foreign tables way more efficiently. This includes join push down (joins can now already be performed remotely) and order push down (sorting can now happen remotely). Distributing data inside a cluster is now way more efficient due to faster remote operations.