We performed a comparison between Chroma and PostgreSQL based on real PeerSpot user reviews.
Find out in this report how the two Vector Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution's most valuable feature is its documentation, which allows new users to easily learn, deploy, and use it."
"It's very easy to set up and runs easily."
"The solution is scalable, it is very good."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."
"The product is easy to use and works fast for relational databases."
"It's a useful solution, that can be widely used."
"We use the solution to store tables. It is stable and performs well."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"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."
"I think Chroma doesn't have a ready-made containerized image available."
"The hybrid algorithm needs improvement."
"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."
"The price could be better."
"I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
Chroma is ranked 3rd in Vector Databases with 2 reviews while PostgreSQL is ranked 7th in Vector Databases with 123 reviews. Chroma is rated 8.6, while PostgreSQL is rated 8.4. The top reviewer of Chroma writes "Used for RAG (Retrieval-augmented generation) and provides good documentation". On the other hand, the top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". Chroma is most compared with Faiss, LanceDB, Redis, Milvus and OpenSearch, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and OpenSearch. See our Chroma vs. PostgreSQL report.
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.