We performed a comparison between PostgreSQL and Redis 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."One of the most valuable features is real-time data capture; it optimizes database performance. I think using real-time data capture reduces job running time and the amount of data sent at once with batch loads."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"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."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"What I like is that it's quite powerful in terms of performance."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"The ability to fetch and save data quickly is valuable."
"The most valuable features of Redis are its ease of use and speed. It does not have access to the disc and it is fast."
"The product offers fast access to my database."
"The solution's technical support team is good...The solution's initial setup process was straightforward."
"Redis is a simple, powerful, and fast solution."
"The in-memory data makes it fast."
"It makes operations more efficient. The information processing is very fast, and very responsive. It's all about the technology."
"The online interface is very fast and easy to use."
"The price could be better."
"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."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"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 could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."
"The only thing is the lack of a GUI application. There was a time when we needed to resolve an issue in production. If we had a GUI, it would have been easier."
"Sometimes, we use Redis as a cluster, and the clusters can sometimes suffer some issues and bring some downtime to your application."
"The initial setup took some time as our technical team needed to familiarize themselves with Redis."
"The development of clusters could improve. Additionally, it would be helpful if it was integrated with Amazon AWS or Google Cloud."
"There is a lack of documentation on the scalability of the solution."
"If we use a lot of data, it will eventually cost us a lot."
"I would prefer it if there was more information available about Redis. That would make it easier for new beginners. Currently, there is a lack of resources."
"In future releases, I would like Redis to provide its users with an option like schema validation. Currently, the solution lacks to offer such functionality."
PostgreSQL is ranked 7th in Vector Databases with 123 reviews while Redis is ranked 4th in Vector Databases with 9 reviews. PostgreSQL is rated 8.4, while Redis is rated 8.6. The top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". On the other hand, the top reviewer of Redis writes "Enables efficient caching and helps users fetch and save data quickly". PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and SQLite, whereas Redis is most compared with Google Cloud Memorystore, Amazon SQS, ActiveMQ, Chroma and Faiss. See our PostgreSQL vs. Redis 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.
