This release includes the following:
Features:
-
Push down ORDER BY to remote MongoDB servers.
If possible, consider a path that adds the ORDER BY clause to the remote SQL so that we get the ordered result set from the foreign server itself. It might help us to have an efficient merge join. -
Push down LIMIT/OFFSET to remote MongoDB servers.
Wherever applicable, perform LIMIT and OFFSET operations on the remote server. This reduces network traffic between local PostgreSQL and remote MongoDB servers.
Other improvements and Fixes:
- Save the status of the enable_aggregate_pushdown option for accessing the aggregation path at a later stage, especially in the case of nested join queries.
- Improve the WHERE clause pushdown. Now recursive operator expressions, boolean expressions, Relabel types, and Var's on both sides of an operator are supported.
- Fix server crash caused due to missed Param node handling. (#160)
- Fix typos in autogen.sh and README.md files. (#153)