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 April 2025, in the Vector Databases category, the mindshare of PostgreSQL is 4.8%, up from 3.4% 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

"PostgreSQL is stable. It's available, stable, and reliable."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"The system can perform faster analysis by providing it with a lot of memory. Speed is crucial for analytics. Currently, the main reason we haven't adopted Elasticsearch is that we lack the necessary expertise to manage it."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way. In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end. As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands."
"The product is easy to use and works fast for relational databases."
"The initial setup was very simple."
"Rockset is very fast, and you can query just like in MySQL."
 

Cons

"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"I had some issues when I integrated with the Jupyter Notebook."
"I'm not really able to customize it."
"We often find the solution's datetime datatype challenging."
"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."
"Sometimes, it becomes slow because of the network. So, there is room for improvement in performance."
"They need to improve the user experience of the management."
"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."
"Filtering the database based on indexes is difficult in Rockset and should be simplified."
"Rockset is now bought by OpenAI. It’s uncertain if Rockset will continue to exist as it is."
 

Pricing and Cost Advice

"Affordable solution."
"It is open source. There is no licensing."
"The need for our customers to pay for licences is contingent on their projects and budgets."
"The community version of Postgre is basically free."
"Our company pays for it. There are free versions available, but for advanced features, you obviously have to pay."
"It is also open-source so it is free."
"It is free. There is no license on it."
"We use the open-source version of PostgreSQL and not the enterprise edition."
Information not available
report
Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
845,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
12%
Comms Service Provider
9%
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: March 2025.
845,406 professionals have used our research since 2012.