timescale/pg_textsearch v0.3.0

on GitHub

What's New

Query Performance

Block-Max WAND optimization delivers up to 4x faster top-k queries by skipping blocks that can't contribute to results. This is the same algorithm used by Lucene and other production search engines.

• Single-term and multi-term queries benefit from block-level score upper bounds
• New GUC pg_textsearch.enable_bmw (default: on) controls the optimization
• New GUC pg_textsearch.log_bmw_stats for debugging block skip statistics

Scalability

• Fixed memory leaks during index builds by using private DSA allocations
• Reduced default memtable spill threshold for more predictable memory usage

Bug Fixes

• Fixed bm25query binary I/O and scoring with detoasted varlena values
• Fixed missing math.h include that caused build failures on some platforms
• Fixed compilation warnings

Under the Hood

• Added competitive benchmark suite comparing against leading Postgres-based text search extension
• Added nightly stress tests with memory leak detection
• Added segment integrity tests
• Added code coverage reporting via Codecov
• Code cleanup: removed dead code, consolidated duplicates

New Contributors

• @TheAifam5 made their first contribution

Full Changelog: v0.2.0...v0.3.0