0.16.0 does not contain breaking changes to existing indexes. However, several settings around index creation have been changed.
Please read the changelog carefully.
New Features 🎉
CREATE INDEX/REINDEXcan now leverage Postgres parallel workers, which significantly improves index build times. To fully take advantage of parallel index builds, some Postgres settings may require tuning. Additionally, the oldparadedb.create_index_*andparadedb.statement_*settings have been removed in favor of the built-inpostgresql.confsettings.- Indexing expressions is a new beta feature for advanced users.
paradedb.snippetnow works for JSON.
Stability Improvements 💪
- Fixed an issue where BM25 scores could be lost in JOIN queries.
Performance Improvements 🚀
- Optimized the insert code path, leading to 2X write throughput over single-row inserts/updates.
- Improved query pushdown to use the BM25 index when we can, even if
@@@is not present in the query.