# PG Vector Reviews **Vendor:** pgvector **Category:** [Vector Database Software](https://www.g2.com/categories/vector-database) **Average Rating:** 3.8/5.0 **Total Reviews:** 12 ## About PG Vector PGVector is an open-source extension for PostgreSQL that enables efficient vector similarity searches directly within the database. It allows users to store and query vector data alongside traditional relational data, facilitating tasks such as machine learning model integration, recommendation systems, and natural language processing applications. Key Features and Functionality: - Vector Storage: Supports single-precision, half-precision, binary, and sparse vectors, accommodating diverse data types. - Similarity Search: Offers both exact and approximate nearest neighbor search capabilities, utilizing distance metrics like L2 (Euclidean, inner product, cosine, L1, Hamming, and Jaccard distances. - Indexing: Provides indexing methods such as HNSW (Hierarchical Navigable Small World and IVFFlat (Inverted File with Flat quantization to optimize search performance. - Integration: Compatible with any language that has a PostgreSQL client, enabling seamless incorporation into existing applications. - PostgreSQL Features: Maintains full support for PostgreSQL's ACID compliance, point-in-time recovery, and JOIN operations, ensuring data integrity and reliability. Primary Value and User Solutions: PGVector addresses the challenge of integrating vector similarity search within relational databases by embedding this functionality directly into PostgreSQL. This integration eliminates the need for external systems or complex data pipelines, simplifying architecture and reducing latency. Users can perform efficient similarity searches on vector data stored alongside their relational data, streamlining workflows in applications like recommendation engines, image and text retrieval, and other AI-driven solutions. ## PG Vector Reviews ### 1. Complicating Data Analysis and Decision Making **Rating:** 2.5/5.0 stars **Reviewed by:** Justin C. | Surveyor, Government Administration, Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2023 **What do you like best about PG Vector?** There is no scalability potential for PG Vector. Initially configuring it is difficult once it is properly set up it handles datasets. Adapting PG Vector, for data requires additional time and resources it proves to be a poor tool for rapid business expansion needing extensive technical expertise. **What do you dislike about PG Vector?** There are drawbacks that needs to be improved. As data difficulty increases, configuring and adjusting PG Vector demands resources and expertise. This poses problems for users who arent well versed in advanced database management techniques. **What problems is PG Vector solving and how is that benefiting you?** Despite the processes provided by PG Vector searching for vectors within large datasets is still time consuming. It is unable to solve difficult data challenges making it a cumbersome asset. PG Vector does not solve the issue of functionality, in vector extensions. ### 2. SQL- PG vector **Rating:** 5.0/5.0 stars **Reviewed by:** Nishant M. | Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** January 16, 2024 **What do you like best about PG Vector?** It helps me to store and quearying the SQL. The implemention of PG vector is perfect, means the UI and the it is easy to use.It has number of feature andd so many people frequently use this software for SQl storing and for vector search. the integration use the AI to manage the data and so more. In this the support is good and the vector extension for sql is the best. **What do you dislike about PG Vector?** some time it is taking time for result to shown up but it is okay. **What problems is PG Vector solving and how is that benefiting you?** It helps me to store the SQL data and querying vectors, It is also use the AI which is so good. ### 3. Making Worst Data Analysis and Decision Making **Rating:** 2.5/5.0 stars **Reviewed by:** Christopher B. | Organizational Economist, Mechanical or Industrial Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2023 **What do you like best about PG Vector?** It needs to be robust when dealing with datasets. It require some setup effort but properly configured it delivers inaccurate results. Even though handling data demand time and resources it does not worth it, for those who need scalability without extensive technical expertise. **What do you dislike about PG Vector?** PG Vector proves to be a poor tool for managing and analyzing data. PG Vector provides solutions for storing and retrieving data the setup process resource intensive and demands specific knowledge. As datasets become larger and more intricate, configuring the system become burdensome. **What problems is PG Vector solving and how is that benefiting you?** PG Vector is unable to solve the issue of vector support in open source databases. By leveraging this extension we are unable to manipulate vector data, resulting in increased performance for our business applications. ### 4. PGVector: Expanding the Capabilities of PostgreSQL **Rating:** 3.5/5.0 stars **Reviewed by:** Miguel Ángel C. | Programador full stack, Small-Business (50 or fewer emp.) **Reviewed Date:** September 30, 2023 **What do you like best about PG Vector?** The best thing about PGVector, from my point of view, is that it makes it easy to find similar things in large amounts of data. This is useful for analyzing information and making decisions based on similarities. It simplifies the search and makes the results more accurate. **What do you dislike about PG Vector?** What I like least about PGVector is that it can be complicated to set up correctly at first, which could be an obstacle if trying to scale to larger datasets. Additionally, as the data becomes more complex, adjusting PGVector to obtain accurate results can take more time and resources, which could make it difficult to use in situations where rapid growth is needed without having deep technical knowledge. **What problems is PG Vector solving and how is that benefiting you?** PGVector solves problems by allowing accurate similarity search of vectors in large datasets. Now, while this has benefited me in terms of accuracy and time-saving in data processing tasks, it is important to mention that as these grow and become more complex, the configuration and tuning of PGVector may require more resources and technical knowledge. ### 5. PG Vector: Game-Changing Embeddings for PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Sangeetha k. | Digital Marketing Associate , Small-Business (50 or fewer emp.) **Reviewed Date:** December 19, 2023 **What do you like best about PG Vector?** PG Vector seamlessly embeds machine learning into PostgreSQL It allows me to unlock powerful semantic search without breaking my existing data stack. **What do you dislike about PG Vector?** For users unfamiliar with ML, understanding and utilizing embeddings effectively might require initial effort. **What problems is PG Vector solving and how is that benefiting you?** I was constantly frustrated by the limitations of traditional search for my projects. Fuzzy matching wouldn't cut it, and integrating dedicated search engines felt like a messy detour. After PG Vector my PostgreSQL database became a powerful hub for semantic search and insightful recommendations. ### 6. Not for me..! **Rating:** 3.0/5.0 stars **Reviewed by:** Neenu P. | Project Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** September 28, 2023 **What do you like best about PG Vector?** The only thing that I felt good about PG Vector it has a number of features that can aid in similarity searches between available vectors. The customer service is also good. **What do you dislike about PG Vector?** The installation of PG Vector is so cumbersome, not user friendly as well. The installation require you to run a set of codes and on Windows, it is mandatory to have C++ pre-installed. The integration is so difficult that makes it less frquently used. **What problems is PG Vector solving and how is that benefiting you?** With PG Vector, it is easier to found similar vectors within the huge database they have. This was tiresome work earlier. Making all the possible vectors in one place makes it a good vector searches. ### 7. A Powerful Tool For Storing and searching Embeddings in PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Kartik s. | Digital marketer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 06, 2023 **What do you like best about PG Vector?** PG vector is used to recommended pruducts to users based on theirs past purchases or interests. it is used to analyze the sentiment of text. and it is very particularly useful for applications involving vector similarity search, such as those build on top of GPT models **What do you dislike about PG Vector?** PG vector is still under development and it is not yet production ready, thats why there are many bugs or performance issues that affecting the stability. PG vector is only compatible with certain versions of postgreSQL. But i have older version of PostgreSQL so it is not compatible . **What problems is PG Vector solving and how is that benefiting you?** Storing and searching embeddings in PostgreSQL it allows me to store and search embeddings in PostgreSQL. this is help me to improve the proformance of natural language. i was Using PG vector to improve the performance of a chatbot that i use to answer customer questions. ### 8. Reviewing PG Vector: Great but not for everyone! **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** December 10, 2023 **What do you like best about PG Vector?** Helps in searching for the exact and approximate nearest neighbors, L2 distance, inner product distance, and cosine distance for each language that has a Postgres client. Easy to setup and integrate. **What do you dislike about PG Vector?** Still not stable when it comes to a lot of new features being added in 5.0 **What problems is PG Vector solving and how is that benefiting you?** Helps in supporting vectors along with the rest of the data all binded together making it easier for users to work with complex vector databases ### 9. PG Vector: Pioneering Innovation in Vector Technologies **Rating:** 5.0/5.0 stars **Reviewed by:** Dhananjay N. | Enterprise (> 1000 emp.) **Reviewed Date:** October 18, 2023 **What do you like best about PG Vector?** PG vectors excels in cutting edge technologies, revolutionizing industries. With robust solutions PG Vector empowers industries to reach new heights. **What do you dislike about PG Vector?** Downsides could includes issues related to pricing or customer services. **What problems is PG Vector solving and how is that benefiting you?** The biggest benefits of PG vector that it addresses complex data challenges by providing efficient storage and retrieval solutions, streamlining processes, and enhancing data processing capabilities. ### 10. Open-Source Vector Extension **Rating:** 4.0/5.0 stars **Reviewed by:** Hari K. | Senior Principle engineer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** August 15, 2023 **What do you like best about PG Vector?** it is a PostgreSQL vector extension that enables rapid similarity searches, flexible indexing, ease of use, and open-source licensing, making it an excellent candidate for various applications. **What do you dislike about PG Vector?** It is currently in progress and can be challenging to set up. **What problems is PG Vector solving and how is that benefiting you?** Vector data can be stored and indexed in PostgreSQL databases. This allows for efficient similarity searches on vector data. ### 11. Best extension out there for PostgresSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** October 02, 2023 **What do you like best about PG Vector?** The ease of use and ease of implementation is the strongest suit of PH Vector. The number of features and frequency of use of these features are very high **What do you dislike about PG Vector?** I would suggest to do a bit better on customer support is where I see a room for improvement **What problems is PG Vector solving and how is that benefiting you?** The DB extension PG Vector is solving the complexity of DB management in my application ### 12. Exploring the power of PG Vector: Open source Vector extension **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 02, 2023 **What do you like best about PG Vector?** Simplicity and ease of access! PG vector enhances PostgreSQL with vector capabilities, a valuable open-source addition **What do you dislike about PG Vector?** Learning curve, compatibility, resource usage , documentation, and maintenance are major disappointment. **What problems is PG Vector solving and how is that benefiting you?** Pg Vector optimizies spatial queries, helping us quickly to find the nearest location in our scenario of efficient delivery locations It enables precise distance calculations ensuring accurate deliver time estimates. - [View PG Vector pricing details and edition comparison](https://www.g2.com/products/pg-vector/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-15+05%3A51%3A43+-0500&secure%5Bsession_id%5D=f786c0c1-8882-4823-a939-d4ceacd38949&secure%5Btoken%5D=864918d77296a3c9ae29222268011b79106df3737b1a73e0576214a1760b5f8a&format=llm_user) ## PG Vector Features **Data Indexing** - Semantic Search - Indexing Data **Filters** - Accurate Search - Single Stage Filtering - Vector Database ## Top PG Vector Alternatives - [Weaviate](https://www.g2.com/products/weaviate/reviews) - 4.6/5.0 (29 reviews) - [Elasticsearch](https://www.g2.com/products/elastic-elasticsearch/reviews) - 4.5/5.0 (287 reviews) - [Supabase](https://www.g2.com/products/supabase-supabase/reviews) - 4.7/5.0 (41 reviews)