timescale/pg_textsearch

View on GitHub

PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.

Stars: 4k
Forks: 119
Open beginner issues: 0
Indexed issues: 27
Avg merge: 6d 3h
Merged PRs (30d): 13

Dominant language: C
License: PostgreSQL
Last GitHub push: Sep 17, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue help wanted

Beginner friendly Everything

Open All

27 open issues indexed

Optimize Boolean queries with cache-backed memtable evaluation Open

Difficulty 5/5 Over a week Newbie friendliness 45/100

timescale/pg_textsearch#499 · Opened Sep 17, 2026
Prevent memtable spill starvation under continuous ranked queries Open

bug performance scope:medium

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#495 · Opened Sep 16, 2026
Benchmark Boolean, phrase, mixed, and COUNT workloads after query support lands Open

enhancement performance scope:medium

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#496 · Opened Sep 16, 2026
Investigate poor read-only disjunction performance in PlanetScale TIN benchmark Open

performance scope:large

Difficulty 5/5 Over a week Newbie friendliness 30/100

timescale/pg_textsearch#497 · Opened Sep 16, 2026
Reduce peak memory during large BM25 index builds Open

performance scope:large

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#498 · Opened Sep 16, 2026
Compaction entry points can act on stale per-index state after concurrent index DDL Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

timescale/pg_textsearch#485 · Opened Sep 3, 2026
Confine at-capacity segments to the deepest reachable level Open

enhancement performance scope:medium

Difficulty 4/5 3-5 days Newbie friendliness 55/100

timescale/pg_textsearch#484 · Opened Sep 3, 2026
Hot-standby BM25 query can fail with invalid segment header after primary merge/reclaim Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 45/100

timescale/pg_textsearch#482 · Opened Sep 2, 2026
Enforce segment format limits consistently across build and merge Open

bug scope:medium

Difficulty 4/5 3-5 days Newbie friendliness 48/100

timescale/pg_textsearch#473 · Opened Aug 29, 2026
REINDEX orphans memtable cache accounting, permanently leaking shared memory budget Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

timescale/pg_textsearch#470 · Opened Aug 26, 2026
Tombstone chain walks don't bound the next-page pointer, so corruption bypasses self-heal Open

Difficulty 3/5 1-2 days Newbie friendliness 78/100

timescale/pg_textsearch#469 · Opened Aug 25, 2026
tp_record_free_index_page() reads a block with no bounds check Open

Difficulty 3/5 1-2 days Newbie friendliness 74/100

timescale/pg_textsearch#468 · Opened Aug 25, 2026
Shared index state is keyed on index OID alone, so template-cloned databases collide Open

Difficulty 4/5 3-5 days Newbie friendliness 58/100

timescale/pg_textsearch#464 · Opened Aug 23, 2026
On-disk uint32 format limits cap a fully-merged segment at a 4 GiB string pool / 268M terms. Is segment splitting (or a wider format) the intended path for very large corpora? Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#456 · Opened Aug 18, 2026
filtered_seed: key the top-K limit stash by scan identity (multi-scan-same-index) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

timescale/pg_textsearch#435 · Opened Aug 6, 2026
Reduce WAL amplification for FRAGMENT chain-page writes Open

performance

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#381 · Opened May 15, 2026
validate_queries.sql: MS MARCO query 158 fails by 1.5 score points (pre-existing tokenization discrepancy) Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 38/100

timescale/pg_textsearch#361 · 2 comments · Opened May 11, 2026
pg_textsearch for linux RHEL 9.7 available ? Open

developer relations

Difficulty 4/5 3-5 days Newbie friendliness 35/100

timescale/pg_textsearch#356 · 1 comment · Opened May 10, 2026
Size-aware LSM compaction policy for segment consolidation Open

performance

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#338 · Opened Apr 22, 2026
Phrase queries with positional information Open

enhancement scope:large

Difficulty 5/5 Over a week Newbie friendliness 25/100

timescale/pg_textsearch#314 · Opened Apr 15, 2026
Background segment compaction Open

enhancement scope:medium

Difficulty 5/5 Over a week Newbie friendliness 25/100

timescale/pg_textsearch#313 · 1 comment · Opened Apr 15, 2026
Feature request: publish debian packages Open

developer relations enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

timescale/pg_textsearch#304 · 3 reactions · Opened Apr 8, 2026
bm25_force_merge: defragment pages into contiguous layout Open

performance scope:medium

Difficulty 5/5 Over a week Newbie friendliness 38/100

timescale/pg_textsearch#243 · Opened Feb 27, 2026
Add way to tokenize and segment words on outside of database Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

timescale/pg_textsearch#159 · 3 comments · Opened Jan 19, 2026
Dictionary compression Open

performance scope:medium

Difficulty 5/5 Over a week Newbie friendliness 25/100

timescale/pg_textsearch#139 · Opened Jan 13, 2026
Version that runs on Windows? Open

enhancement good first issue help wanted

Difficulty 5/5 Over a week Newbie friendliness 25/100

timescale/pg_textsearch#82 · 2 comments · Opened Dec 19, 2025
Index multiple columns within one index Open

enhancement scope:large

Difficulty 5/5 Over a week Newbie friendliness 25/100

timescale/pg_textsearch#80 · 2 comments · 1 reaction · Opened Dec 17, 2025

timescale/pg_textsearch

Get new issues in your inbox