MongoDB, MySQL, Hadoop (HDFS) Foreign Data Wrappers updated to support PostgreSQL 16

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

EDB is pleased to announce new releases of MongoDB, MySQL, and Hadoop (HDFS) Foreign Data Wrappers to support the upcoming PostgreSQL 16 release. These Foreign Data Wrappers allow Postgres to connect to Hadoop, MongoDB, and MySQL servers enabling you to view, join, and manage remote data all from Postgres.

Highlights of these releases include:

MongoDB FDW 5.5.1

• Enhancement: Added support for PostgreSQL 16
• Enhancement: GUCs added: enable_join_pushdown and enable_aggregate_pushdown
• Feature: Table/Server level option added: enable_order_by_pushdown

MySQL FDW 2.9.1

• Enhancement: Added support for PostgreSQL 16
• Enhancement: Added operators and functions entries in the default mysql_fdw_pushdown.config file
• Bug: Fixed incorrect quoting in generating EXPLAIN query
...

Get the full details here: PostgreSQL: MongoDB, MySQL, Hadoop (HDFS) Foreign Data Wrappers updated to support PostgreSQL 16