MongoDB Foreign Data Wrapper 5.5.0 release notes v5

Released: 06 Jan 2023

Enhancements, bug fixes, and other changes in MongoDB Foreign Data Wrapper 5.5.0 include:

TypeDescription
FeatureWhen possible, we push the ORDER BY clause to the remote MongoDB server. This approach provides the ordered result set from the foreign server, which can help to have an efficient merge join.
FeatureWhen possible, perform LIMIT and OFFSET operations on the remote server. This reduces network traffic between local Postgres and remote MongoDB servers.
EnhancementImproved the WHERE clause pushdown to remote MongoDB servers. Now supports recursive operator expressions, Boolean expressions, relabel types, and vars on both sides of an operator.
Bug FixFor nested join queries, save the status of the enable_aggregate_pushdown option to access the aggregation path later.
Bug FixFix server crash due to missing Param node handling.
Bug FixFix typos in autogen.sh and README.md files.