# Open Source pg\_vectorsearch Brings More Scalable Vector Search to PostgreSQL

DevFeed: [Open Source pg\_vectorsearch Brings More Scalable Vector Search to PostgreSQL](<https://devfeed.tech/articles/open-source-pg-vectorsearch-brings-more-scalable-vector-search-to-postgresql-122002.md>)

Original publisher: [Read original article](<https://www.infoq.com/news/2026/11/postgresql-vector-search/>)

Author: Renato Losio

Published: 2026-11-07T09:49:00Z

Content type: news

Language: en

Sources: [InfoQ](<https://devfeed.tech/sources/infoq.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [ann](<https://devfeed.tech/topics/ann.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-ml-data-engineering](<https://devfeed.tech/tags/ai-ml-data-engineering.md>), [algorithm](<https://devfeed.tech/tags/algorithm.md>), [alpha](<https://devfeed.tech/tags/alpha.md>), [approximate-nearest-neighbor](<https://devfeed.tech/tags/approximate-nearest-neighbor.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [compression](<https://devfeed.tech/tags/compression.md>), [data-partitioning](<https://devfeed.tech/tags/data-partitioning.md>), [database](<https://devfeed.tech/tags/database.md>), [development](<https://devfeed.tech/tags/development.md>), [extension](<https://devfeed.tech/tags/extension.md>), [hnsw](<https://devfeed.tech/tags/hnsw.md>), [index](<https://devfeed.tech/tags/index.md>), [memory](<https://devfeed.tech/tags/memory.md>), [ml-data-engineering](<https://devfeed.tech/tags/ml-data-engineering.md>), [news](<https://devfeed.tech/tags/news.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [pg-vectorsearch](<https://devfeed.tech/tags/pg-vectorsearch.md>), [pgvector](<https://devfeed.tech/tags/pgvector.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-vector-search](<https://devfeed.tech/tags/postgresql-vector-search.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [search](<https://devfeed.tech/tags/search.md>), [similarity](<https://devfeed.tech/tags/similarity.md>), [similarity-search](<https://devfeed.tech/tags/similarity-search.md>), [tiger-data](<https://devfeed.tech/tags/tiger-data.md>), [vector](<https://devfeed.tech/tags/vector.md>), [vector-databases](<https://devfeed.tech/tags/vector-databases.md>), [vectorsearch](<https://devfeed.tech/tags/vectorsearch.md>)

## AI overview

Tiger Data's alpha pg_vectorsearch adds PRISM vector indexing to PostgreSQL, using hierarchical clustering, compressed partitions, and RaBitQ quantization to narrow searches and scan vectors sequentially. It supports existing pgvector columns and uses PostgreSQL's storage and concurrency mechanisms. In Tiger Data's benchmark on 100 million vectors, PRISM built an index in 1 hour 40 minutes on a 128 GB machine; HNSW took 42 hours on a 512 GB machine. The results have not been independently validated. The extension requires PostgreSQL 18 or later, supports up to 1,968 dimensions, and does not yet support filtered searches combining WHERE and ORDER BY. It is in alpha, and incomplete incremental rebalancing means frequent data changes may require rebuilding the index to maintain search efficiency.

## Source excerpt

Tiger Data has released pg_vectorsearch, an open source PostgreSQL extension for vector similarity search, currently in alpha. Its PRISM index uses data partitioning and compression instead of the graph-based approach used by pgvector's HNSW index, reducing memory requirements and index build times. By Renato Losio