Release v2.0.3
The following functionality was added in order to ensure executions of TPC-H benchmark with HDFS_FDW with small data size
1- Parametrised where clause push down
2- Enable remote estimates
3- Option to log remote SQL
4- Option to specify fetch size
5- Add test cases in regression for parametrised and non-parametrised where push-down
6- Performance improvement by eliminating the need of describing remote table before query
7- Fix remote query costing
In addition to this, support for PG 10 is also added as part of this release.
Overall, the quality and stability of HDFS_FDW is greatly improved with this release. The TPC-H benchmark can be executed with HDFS_FDW with small data size, we have tested with multiple GB's of data. The enhancements for pushing down aggregates, sorts and joins will come next and will enable HDFS_FDW to run TPC-H benchmark with large data size.