pgvector
1-Click installation template for pgvector on Easypanel
Description​
pgvector is an open-source app designed to facilitate vector similarity search for Postgres. It allows you to store all your application data in one place, supporting both exact and approximate nearest neighbor search. The app is capable of handling L2 distance, inner product, and cosine distance, making it versatile for various data analysis needs. It is compatible with any language that has a Postgres client. The app also boasts of ACID compliance, point-in-time recovery, JOINs, and all the other great features of Postgres. With pgvector, you can create a new table with a vector column or add a vector column to an existing table, insert vectors, upsert vectors, update vectors, and delete vectors. It also allows you to get the nearest neighbors to a vector or a row, and get rows within a certain distance. The app also supports indexing for improved search performance. It is a powerful tool for managing and analyzing your data in a Postgres environment.
Benefits​
- Unified Data Storage: pgvector allows you to store all of your application data in one place, eliminating the need for multiple databases or storage solutions.
- Advanced Search Capabilities: The app supports exact and approximate nearest neighbor search, enabling you to find the most relevant data quickly and efficiently.
- Versatile Distance Measures: pgvector supports various distance measures including L2 distance, inner product, and cosine distance, providing flexibility in how you search and compare data.
- ACID Compliance and Recovery Features: With ACID compliance and point-in-time recovery, pgvector ensures the integrity and reliability of your data.
- Integration with Postgres: pgvector integrates seamlessly with Postgres, allowing you to leverage all of the features of this popular database system.
Features​
- Vector Similarity Search: pgvector allows you to perform vector similarity searches in Postgres, making it easier to find and retrieve relevant data.
- Data Manipulation: You can easily create new tables with vector columns, add vector columns to existing tables, insert vectors, update vectors, and delete vectors.
- Querying: pgvector provides a variety of querying options, including getting the nearest neighbors to a vector or a row, and getting rows within a certain distance.
- Indexing: pgvector supports exact and approximate nearest neighbor search indexing, allowing you to optimize your search performance.
- Multi-language Support: pgvector can be used from any language with a Postgres client, offering flexibility in how you interact with your data.
Links​
Options​
| Name | Description | Required | Default Value |
|---|---|---|---|
| Service Name | - | yes | |
| Service Image | - | yes | ankane/pgvector:v0.4.4 |
Screenshots​
Change Log​
- 2023-06-30 – first release