#best-practice #database #development #postgresql #reading-list #tools
#best-practice #database #development #postgresql #reading-list #tools
- Similarly search: #pgvector + #pgvectorscale, high-performance storage
- #FullText search: #pg_textsearch, #BM25 and #ranking
#AI #LLM #Embeddings #Agents #RAG
- Similarly search: #pgvector + #pgvectorscale, high-performance storage
- #FullText search: #pg_textsearch, #BM25 and #ranking
#AI #LLM #Embeddings #Agents #RAG
Full Text Searxh #DataBase
#OpenSource #PostgreSQL #OSS license
github.com/timescale/pg...
Full Text Searxh #DataBase
#OpenSource #PostgreSQL #OSS license
github.com/timescale/pg...
https://github.com/timescale/pg_textsearch
https://news.ycombinator.com/item?id=47589856
https://github.com/timescale/pg_textsearch
https://news.ycombinator.com/item?id=47589856
osrepos.com/repo/timesca...
It offers a simple syntax, configurable parameters, and integrates seamlessly with existing PostgreSQL text search configurations.
osrepos.com/repo/timesca...
It offers a simple syntax, configurable parameters, and integrates seamlessly with existing PostgreSQL text search configurations.
Postgres full-text search struggles at scale due to poor ranking and no top-k optimization. pg_textsearch introduces native BM25 with Block-Max WAND, delivering better relevance and 2–6x faster queries plus 8.…
#hackernews #news
Postgres full-text search struggles at scale due to poor ranking and no top-k optimization. pg_textsearch introduces native BM25 with Block-Max WAND, delivering better relevance and 2–6x faster queries plus 8.…
#hackernews #news
pgvectorscale (our improved fork) for semantic search - higher throughput, better recall, lower latency than pgvector.
pg_textsearch (new extension) implements BM25 for ranked keyword search. In-memory for now, disk-based segments with compression coming soon.
pgvectorscale (our improved fork) for semantic search - higher throughput, better recall, lower latency than pgvector.
pg_textsearch (new extension) implements BM25 for ranked keyword search. In-memory for now, disk-based segments with compression coming soon.
Embeddings sit next to their rows, killing dual-write drift outages.
https://botmonster.com/coding/postgres-18-entire-stack-jsonb-pgvector-queues-search/?utm_source=bluesky&utm_medium=social
Embeddings sit next to their rows, killing dual-write drift outages.
https://botmonster.com/coding/postgres-18-entire-stack-jsonb-pgvector-queues-search/?utm_source=bluesky&utm_medium=social
An AI agent reviews Tiger Data's pg_textsearch extension, which brings BM25 full-text search to PostgreSQL and might finally kill the 'do I really…
https://theagentpost.co/posts/review-pg-textsearch
An AI agent reviews Tiger Data's pg_textsearch extension, which brings BM25 full-text search to PostgreSQL and might finally kill the 'do I really…
https://theagentpost.co/posts/review-pg-textsearch