- 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
- MCP server
- Nearly-zero cost database forks
- Hybrid vibe search (vector + BM25)
www.tigerdata.com/agentic-post...
- MCP server
- Nearly-zero cost database forks
- Hybrid vibe search (vector + BM25)
www.tigerdata.com/agentic-post...
https://postgr.es/p/9hd
#postgresql
https://postgr.es/p/9hd
#postgresql
PostgreSQLを生成AIの情報源として使える高速ベクトルデータベース化拡張「Pgvectorscale」がオープンソースで公開。Pgvectorをさらに高性能化
PostgreSQLを生成AIの情報源として使える高速ベクトルデータベース化拡張「Pgvectorscale」がオープンソースで公開。Pgvectorをさらに高性能化
TL;DR pgvector is awesome
#OpenSource #VectorDatabase #PostgreSQL
www.timescale.com/blog/pgvecto...
TL;DR pgvector is awesome
#OpenSource #VectorDatabase #PostgreSQL
www.timescale.com/blog/pgvecto...
#HackerNews
<a href="https://github.com/timescale/pgvectorscale" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://github.com/timescale/pgvectorscale
#HackerNews
<a href="https://github.com/timescale/pgvectorscale" class="hover:underline text-blue-600 dark:text-sky-400 no-card-link" target="_blank" rel="noopener" data-link="bsky">https://github.com/timescale/pgvectorscale
github.com/timescale/pg...
pgexperts.com
#PostgreSQL #pgvector #RAG
github.com/timescale/pg...
pgexperts.com
#PostgreSQL #pgvector #RAG
It also adds statistical binary quantization for improved search recall over regular quantization.
PlanetScale supports both. Try them today.
It also adds statistical binary quantization for improved search recall over regular quantization.
PlanetScale supports both. Try them today.
2. New SQL (PostgreSQL w Citus, Hydra, pg_duckdb etc)
3. Document (PostgreSQL w Pongo, Ferretdb etc)
4. Vector (PostgreSQL w pgvector, pgvectorscale, pgai, pg_vectorize etc)
Pick one from each category:
1. Mainstream SQL (PostgreSQL, MySQL, SQLite)
2. New SQL (Cockroach, TiDB, Yugabyte, Oceanbase)
3. Document (Mongo, Elasticsearch, FaunaDB, Meilisearch, Quickwit, VictoriaLogs)
2. New SQL (PostgreSQL w Citus, Hydra, pg_duckdb etc)
3. Document (PostgreSQL w Pongo, Ferretdb etc)
4. Vector (PostgreSQL w pgvector, pgvectorscale, pgai, pg_vectorize etc)
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.
this says better throughput: www.tigerdata.com/blog/pgvecto...
this goes into detail why it adds complexity
alex-jacobs.com/posts/the-ca...
this says better throughput: www.tigerdata.com/blog/pgvecto...
this goes into detail why it adds complexity
alex-jacobs.com/posts/the-ca...
https://www.publickey1.jp/blog/24/postgresqlaipgvectorscalepgvector.html
https://www.publickey1.jp/blog/24/postgresqlaipgvectorscalepgvector.html