Performance Improvements πŸš€

  • We have significantly improved write throughput by optimizing our segment merge policy. We introduced a new setting, paradedb.segment_merge_scale_factor, which allows expensive merge operations to be deferred until a certain number of small segments have accumulated.
  • Implemented pushdown of IS NOT NULL into the custom scan

Stability Improvements πŸ’ͺ

  • We have significantly optimized the size of the BM25 index on disk. Prior to this release, the BM25 index would unconditionally extend the size of the index on disk on every INSERT/UPDATE/COPY if VACUUM had not been run. Now, the BM25 index is able to return β€œdead” space to the Postgres free space map as part of an INSERT/UPDATE/COPY, which means that these statements are able to reclaim existing space.

New Contributors πŸ‘‹

Full Changelog

The full changelog is available here.