Pgvector vs. Redis
Compare Pgvector vs. Redis by the following set of capabilities. We want you to choose the best database for you, even if it’s not us.
Pgvector vs. Redis on Scalability
Yes. pgvector enables separation of storage and compute by allowing you to store your application data on one database while storing vectors, lookup values, and filter values on a separate database.
No. Redis primarily operates by keeping data in memory. The classic architecture of Redis does not inherently follow the storage-compute separation architecture. Instead, it tightly couples data storage and computation in the same node or instance to ensure data access performance.
No. It only scales at the server level. In addition, you need to reshard all the data when scaling out a Redis cluster.
Yes - built-in replication; HA provided in an additional layer by Reis Cluster or Redis Sentinel)
With Redis Enteprise
pgvector scalability
You can use a solution like YugaByteDB to extend the capabilities of Postgres for distributed environments.
Redis Scalability
High Availabiltiy can be achieved with Redis Enterprise.
Pgvector vs. Redis on Functionality
Performance is the biggest challenge with vector databases as the number of unstructured data elements stored in a vector database grows into hundreds of millions or billions, and horizontal scaling across multiple nodes becomes paramount.
Furthermore, differences in insert rate, query rate, and underlying hardware may result in different application needs, making overall system tunability a mandatory feature for vector databases.
Yes. Sparse & Dense Vectors and Scalar filtering.
Yes - Pre-filtering documents against an index containing searchable fields
HNSW & IVFFlat
HNSW & IVFFlat
Redis
Redis has supprt for similarity queries search with the use of vector fields; It is important to note that the k default LIMIT is 10.
Pgvector vs. Redis on Purpose-built
pgvector is an add-on to Postgres
Add on to Redis
No
Use pgvector from any language with a Postgres client
Python for Vector Search
Pgvector vs. Redis: what’s right for me?
Pgvector
pgvector is a PostgreSQL extension designed to facilitate the storage, querying, and indexing of vectors within a PostgreSQL database.
License: PostgreSQL License
Redis is an in-memory data structure store used as a database, cache, message broker, and streaming engine that has a vector field type for the storage, querying and indexing of vectors.
License: BSD License