We performed a comparison between Pinecone and PostgreSQL based on real PeerSpot user reviews.
Find out what your peers are saying about Elastic, Meta, Chroma and others in Vector Databases."We chose Pinecone because it covers most of the use cases."
"The most valuable features of the solution are similarity search and maximal marginal relevance search for retrieval purposes."
"The performance is good."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"It's a useful solution, that can be widely used."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"The initial setup is quick and easy."
"PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"Onboarding could be better and smoother."
"The product fails to offer a serverless type of storage capacity."
"The database and applications can become very slow."
"I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"They need to improve the user experience of the management."
"Sometimes, the views create problems. If you don't have the view, sometimes what happens is you need to have the drivers properly set up for PostgreSQL."
"Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install."
"It could be more secure."
"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database."
Pinecone is ranked 5th in Vector Databases with 2 reviews while PostgreSQL is ranked 7th in Vector Databases with 123 reviews. Pinecone is rated 8.0, while PostgreSQL is rated 8.4. The top reviewer of Pinecone writes "A reliable cloud solution for building an ERP dashboard". On the other hand, the top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". Pinecone is most compared with OpenSearch, Faiss, Elastic Search, Qdrant and Redis, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and SQLite.
See our list of best Vector Databases vendors.
We monitor all Vector Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.