timescaletimescale/pg_textsearch/CLAUDE.md

pg_textsearch

CLAUDE.md4.1k starsChanged 11 months agoPostgreSQLView on GitHub

pg_textsearch is a Postgres extension providing full-text search with BM25 ranking. (Internal name: Tapir) It implements a memtable-based architecture similar to LSM trees, with in-memory structures that spill to disk…

We split this CLAUDE.md into the rules it gives an agent

8 rules. About 0 are common, 2 are distinctive, and 6 are very specific to this project.

≈0
Common · estimate
Many files like this have a rule of this kind.
≈2
Distinctive · estimate
This author's own choices. Worth a look.
6
Very specific
Tied to their project's names, files or tools. Probably skip.

Licensed with conditions — read it at the source. We count its rules but don't quote them. Read them on GitHub.

≈ “Common” is an estimate: at least 1 in 5 of the 25,680 CLAUDE.md files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Jan 23, 2026[New Extension]: pg_textsearch — cloudnative-pg/postgres-extensions-containers2 reactions · 2 comments
Jan 11, 2026 pg_textsearch — electric-sql/pglite2 reactions · 10 comments
Oct 11, 2026postgresqlPackages.pg_textsearch: 1.4.0 -> 1.5.1 — NixOS/nixpkgs1 reaction · 5 comments
May 31, 2026postgresqlPackages.pg_textsearch: 1.2.0 -> 1.3.0 — NixOS/nixpkgs1 reaction · 2 comments
Oct 23, 2026postgresqlPackages.pg_textsearch: mark broken on PostgreSQL 19 — NixOS/nixpkgs0 reactions · 1 comment

32 more on GitHub

Oct 21, 2026test: avoid TCP port collisions in recovery tests — sjmaple/cr-pg_textsearch0 reactions
Oct 9, 2026Package request: timescale/pg_textsearch v1.5.0 — pgdg-packaging/pgdg-rpms0 reactions
Oct 9, 2026Package request: timescale/pg_textsearch v1.5.1 — pgdg-packaging/pgdg-rpms0 reactions
Oct 6, 2026Update dependency timescale/pg_textsearch to v1.5.1 — xataio/postgres-images0 reactions
Oct 6, 2026Add search extensions to postgres database — EOSC-Data-Commons/metadata-warehouse0 reactions
Oct 5, 2026Bump pg_textsearch to 1.5.1 — joeychilson/railway-pgvectorscale-textsearch0 reactions
Oct 1, 2026Package request: pg_textsearch — pgdg-packaging/apt.postgresql.org-issues0 reactions · 1 comment
Aug 26, 2026Implement BM25 keyword retrieval with pg_textsearch — gwkline/homelab0 reactions · 5 comments
Aug 26, 2026Package pg_textsearch as a PostgreSQL 18 CNPG extension image — gwkline/homelab0 reactions · 12 comments
Aug 24, 2026Bump pg_textsearch to 1.4.0 — joeychilson/railway-pgvectorscale-textsearch0 reactions
Aug 20, 2026postgresqlPackages.pg_textsearch: 1.3.1 -> 1.4.0 — NixOS/nixpkgs0 reactions · 1 comment
Aug 14, 2026Design PostgreSQL-native P1 retrieval plane — writeitai/remember-stack0 reactions
Aug 5, 2026Report the hybrid_search bind-order defect upstream and send the fix to archi-physics/archi (#542) — fasrc/archi0 reactions · 3 comments
Jul 23, 2026Add pg_textsearch to repo — pgdg-packaging/pgdg-rpms0 reactions · 2 comments
Jul 5, 2026release(postgresql): update timescale/pg_textsearch ( v1.3.0 → v1.5.1 ) — mlipscombe/containers0 reactions
Jun 27, 2026postgresqlPackages.pg_textsearch: 1.3.0 -> 1.3.1 — NixOS/nixpkgs0 reactions · 2 comments
May 14, 2026postgresqlPackages.pg_textsearch: 1.1.0 -> 1.2.0 — NixOS/nixpkgs0 reactions · 1 comment
May 13, 2026pg_textsearch: 1.1.0 -> 1.2.0 — NixOS/nixpkgs0 reactions · 3 comments
Apr 20, 2026Add pg_textsearch extension — zalando/spilo0 reactions · 2 comments
Apr 3, 2026Upgrade keyword search to BM25 via pg_textsearch — salishforge/memforge0 reactions
Apr 2, 2026[failure] Show HN: Postgres extension for BM25 relevance-ranked full-text search — steveash/hitchhikers-guide-to-ai-native-engineering0 reactions · 1 comment
Mar 12, 2026fix: prevent ResourceOwnerEnlarge crash during transaction abort — constructive-io/pg_textsearch0 reactions
Mar 12, 2026reproduce and document pg_textsearch ResourceOwnerEnlarge bug (issue … — constructive-io/pg_textsearch_repro0 reactions
Mar 11, 2026pg_textsearch on new PGlite — electric-sql/pglite0 reactions · 14 comments
Feb 26, 2026Support pg_textsearch plugin? — Jaymon/prom0 reactions
Feb 14, 2026Use postgres extension for BM25 ranking — linminhtoo/andromeda0 reactions · 1 comment
Feb 12, 2026Bump pg_textsearch to v0.5.1 — timescale/timescaledb-docker-ha0 reactions
Feb 10, 2026"Scripts" -> "Create Script" does not contain additional index parameters WITH, gist_trgm_ops(siglen) — pgadmin-org/pgadmin40 reactions · 2 comments
Feb 4, 2026Add pg_textsearch — Ladybug-Memory/pgembed0 reactions
Jan 11, 2026backend impl of pg_searchtext — electric-sql/postgres-pglite0 reactions · 1 comment
Dec 20, 2025[News] 投稿 — Yuyz0112/koala-oss-app0 reactions · 4 comments
Dec 19, 2025Translation memory and search backends — WeblateOrg/weblate0 reactions · 1 comment

On Hacker News · 8

Mar 31, 2026Show HN: Postgres extension for BM25 relevance-ranked full-text search203 points · 56 comments
Dec 26, 2025Pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search4 points
Dec 16, 2025PostgreSQL extension for BM25 relevance-ranked full-text search4 points
Dec 16, 2025PostgreSQL extension for BM25 relevance-ranked full-text search4 points
Dec 21, 2025Pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search2 points

3 more on Hacker News

Dec 20, 2025Pg_textsearch is now open-source2 points
Dec 15, 2025PostgreSQL extension for BM25 relevance-ranked full-text search2 points
Dec 19, 2025PostgreSQL extension for BM25 relevance-ranked full-text search1 point

On Bluesky · 8

Apr 14, 2026#BM25 search extension for PostgreSQL DB Full Text Searxh #DataBase #OpenSource #PostgreSQL #OSS license github.com/timescale/pg... — @qdrddr.bsky.social3 likes and reposts
Aug 1, 2026https://github.com/timescale/pg_textsearch — @sigmanor.net1 likes and repost
Apr 1, 2026Show HN: Postgres extension for BM25 relevance-ranked full-text search https://github.com/timescale/pg_textsearch… — @hn100.atproto.rocks1 likes and repost
Mar 31, 2026Show HN: Postgres extension for BM25 relevance-ranked full-text search — @hackernewsrobot.bsky.social1 likes and repost
Mar 31, 2026Show HN: How This Graybeard Built the Fastest and Freest Postgres BM25 Search https://github.com/timescale/pg_textsearch… — @betterhn20.e-work.xyz1 likes and repost

3 more on Bluesky

Dec 19, 2025pg_textsearch : Modern ranked text search for Postgres. github.com/timescale/pg... — @ytroncal.bsky.social1 likes and repost
Dec 19, 2025I'm so grateful to Timescale for open sourcing this! — @zebudu.bsky.social1 likes and repost
Dec 18, 2025pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search https://lobste.rs/s/n0gjzd #databases — @lobsters-feed.bsky.social1 likes and repost

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

Reviews can't be read right now.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free