Try our new research platform with insights from 80,000+ expert users

PostgreSQL vs Rockset comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 5, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

PostgreSQL
Ranking in Vector Databases
9th
Average Rating
8.4
Reviews Sentiment
7.7
Number of Reviews
125
Ranking in other categories
Open Source Databases (2nd)
Rockset
Ranking in Vector Databases
17th
Average Rating
8.0
Reviews Sentiment
8.2
Number of Reviews
2
Ranking in other categories
AWS Marketplace (41st)
 

Mindshare comparison

As of May 2025, in the Vector Databases category, the mindshare of PostgreSQL is 4.9%, up from 3.5% compared to the previous year. The mindshare of Rockset is 0.2%, up from 0.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Vector Databases
 

Featured Reviews

AdityaSharma3 - PeerSpot reviewer
Transaction processes are fast and good replication capability
Use cases include querying data warehouses and databases to fetch data for clients already working on PostgreSQL.  We also use Postgres for building reports It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping. The query speed is fast, and the…
Raghavendra Sao - PeerSpot reviewer
Used to get data from the database faster
Rockset is an easy tool, and anyone can use it. The solution provides some type of data grouping. This grouping of data based on some parameters is not simple, but it is very useful. I would recommend the solution to other users. Overall, I rate the solution an eight out of ten.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"The solution is open-source and free to use."
"The initial setup is quick and easy."
"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."
"The performance is good."
"Initial setup is simple."
"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
"It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin. It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers."
"Rockset is very fast, and you can query just like in MySQL."
"The initial setup was very simple."
 

Cons

"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 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."
"PostgreSQL could improve by adding data warehousing tools."
"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."
"Postgres should focus on building a stronger knowledge base. They also need to expand their integration capabilities, so more tools and resources are available to manage it."
"The user interface could be a bit better."
"I don't think PostgreSQL supports bulk databases, so it needs to have more capabilities in terms of managing the bulk data."
"The solution could improve the integration."
"Rockset is now bought by OpenAI. It’s uncertain if Rockset will continue to exist as it is."
"Filtering the database based on indexes is difficult in Rockset and should be simplified."
 

Pricing and Cost Advice

"PostgreSQL is a free and open-source database."
"The community version of Postgre is basically free."
"The tool is cheaply priced compared to other RDBMS providers in the market."
"The licensing model is good."
"It is free. There is no license on it."
"This solution can offer a cheaper choice for customers since it is open-source."
"It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft."
"It is also open-source so it is free."
Information not available
report
Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
12%
Comms Service Provider
10%
Manufacturing Company
8%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

How does Firebird SQL compare with PostgreSQL?
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit yo...
What do you like most about PostgreSQL?
It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping.
What is your experience regarding pricing and costs for PostgreSQL?
The tool is free of cost. For now, it's not about making money. But once we perfect it, we can offer it to customers willing to pay for support and other services. Most of my deployments are free.
What needs improvement with Rockset?
For our use, there is no room for improvement. It depends on how you use it, however, from our perspective, it has met our needs.
What is your primary use case for Rockset?
We used Rockset as an SQL interface on some of DynamoDB. Our use case is primarily for customer-facing data reporting.
What advice do you have for others considering Rockset?
Rockset is now bought by OpenAI. It’s uncertain if Rockset will continue to exist as it is. OpenAI may have its own agenda for it. They have started canceling some contracts with customers, so this...
 

Comparisons

 

Overview

 

Sample Customers

1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
1. Adobe 2. Cisco 3. Comcast 4. DoorDash 5. Expedia 6. Facebook 7. GitHub 8. IBM 9. Lyft 10. Microsoft 11. Netflix 12. Oracle 13. Pinterest 14. Reddit 15. Salesforce 16. Slack 17. Spotify 18. Square 19. Target 20. Twitter 21. Uber 22. Verizon 23. Visa 24. Walmart 25. Yelp 26. Zoom 27. Airbnb 28. Dropbox 29. eBay 30. Google 31. LinkedIn 32. Amazon
Find out what your peers are saying about PostgreSQL vs. Rockset and other solutions. Updated: April 2025.
849,963 professionals have used our research since 2012.