This is ZomboDB v5.6.4-1.0.0_beta1 which supports only Elasticsearch v5.6.4. This is a major upgrade for ZomboDB as it requires Elasticsearch v5.6.4.
For here out, ZomboDB's versioning scheme will reference the supported Elasticsearch point release version first, followed by the major.minor.point release version of ZomboDB as it relates to that version of Elasticsearch.
Going forward, you will need to download the specific version of ZomboDB that supports your specific point release of Elasticsearch 5.6. As of this writing, that point release is v5.6.4.
Aside from security issues or really severe bugs, the ZomboDB releases that support Elasticsearch v1.7 and v2.4 will no longer be supported for free. Please contact ZomboDB, LLC if you require custom work or bug fixes for these older versions.
ZomboDB v5.6.4-1.0.0 brings significant performance improvements across the board. A non-exhaustive list is
SELECTstatement doesn't use
SELECTstatements (by just hardcoding to 2500) to eliminate per-query "
_count" ES endpoint calls. See new index option named
default_row_estimateand Postgres session settings named
_sourcein the Elasticsearch index so that the indexes can be also used by 3rd-party tools such as Kibana. See the index setting named
http.compressioncan optionally be set if it's necessary for your deployment
While this version's SQL and query syntax is backwards compatible with previous versions, ZomboDB does not provide an upgrade path from previous versions that used ES 1.7 or 2.4. As such, you'll need to
DROP INDEX all of your
USING zombodb indexes, install this version of ZomboDB on your new ES 5.6.4 cluster and your Postgres instance, and then re-create the indexes from scratch.
Note that this is a beta release for ES 5.6.4 support. It is believed to be solid but additional testing is appreciated. If no complaints come in, a final release should be out before the end of the year.
If you require assistance with this or require a custom upgrade solution, please feel free to contact ZomboDB, LLC.