timescale/pg_textsearch v0.0.4

on GitHub

pg_textsearch v0.0.4

Features

• Full-text search with BM25 ranking for PostgreSQL
• Memtable-based architecture with shared memory storage
• Support for PostgreSQL 17 and 18
• Crash recovery via document ID tracking
• Memory budget enforcement per index

Improvements

• Fixed version strings from v0.0.4-dev to v0.0.4
• Improved test cleanup (memory test now drops extension)
• Fixed NULL pointer dereference in UPDATE operations
• Enhanced BM25 score validation and IDF calculation

Installation

CREATE EXTENSION pg_textsearch;

Basic Usage

CREATE INDEX idx_docs_bm25 ON documents USING bm25(content) WITH (text_config='english');
SELECT * FROM documents WHERE content <@> to_bm25query('postgresql', 'idx_docs_bm25') < -0.0 ORDER BY content <@> to_bm25query('postgresql', 'idx_docs_bm25') LIMIT 10;

Note: This is prerelease software and should not be used in production.