ClickHouse vs PostgreSQL comparison

ClickHouse and PostgreSQL are both solutions in the Open Source Databases category. ClickHouse is ranked #8 with an average rating of 8.9, while PostgreSQL is ranked #2 with an average rating of 8.4. Additionally, 100% of ClickHouse users are willing to recommend the solution, compared to 96% of PostgreSQL users who would recommend it.

ClickHouse

Read 9 ClickHouse reviews

345 Views
277 Comparison Views

100% willing to recommend

PostgreSQL

Read 125 PostgreSQL reviews

10,676 Views
8,893 Comparison Views

96% willing to recommend

ClickHouse

PostgreSQL

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between ClickHouse and PostgreSQL based on real PeerSpot user reviews.

Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed ClickHouse vs. PostgreSQL Report (Updated: October 2024).

Buyer's Guide

ClickHouse vs. PostgreSQL

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

ClickHouse

Ranking in Open Source Databases

8th

Ranking in Vector Databases

11th

Average Rating

8.8

Number of Reviews

Ranking in other categories

No ranking in other categories

PostgreSQL

Ranking in Open Source Databases

2nd

Ranking in Vector Databases

9th

Average Rating

8.4

Reviews Sentiment

7.9

Number of Reviews

125

Ranking in other categories

No ranking in other categories

Featured Reviews

Dmitriy Yugin

Senior Data/Web Analyst at Raiffeisen Bank

Can set it up on computer and run queries without depending on the cloud

The tool is open-source, so you don't need to pay for the software itself. However, you need to consider hardware costs and maintenance. A small company can install it on a company computer. For larger companies, you might need to hire a team for maintenance and consider data safety and privacy issues. Integrating ClickHouse with other tools in our data stack was easy. It has native connections to many tools, such as Google and Amazon cloud solutions, and can easily connect with other databases. For beginners, the ease of use depends on your background. If you're familiar with relational databases, it's easy. If not, you might need to read the documentation or ask for support.

Read full review

AdityaSharma3

Vice President Business at Techmagnate: Digital Marketing Agency

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…

Read full review

Quotes from Members

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

Pros

"The tool is column-based and infinitely scalable."

"The best thing about the tool is that I can set it up on my computer and run queries without depending on the cloud. This is why I use it every day."

"The main feature of ClickHouse is the optimizer because we had too many records to deduplicate, and the optimizer took this task by itself."

"The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility."

"ClickHouse is much faster than traditional databases like MySQL and MongoDB. Its column-row searching strategy makes it very efficient. With ClickHouse, we can manage multiple databases, automatically insert data from other databases and delete data as needed. It supports real-time query performance, allowing simultaneous data insertion and retrieval. ClickHouse has improved significantly over the past two years, adding more functions and queries, as well as top functionality."

"It's easier to work with big data and calculations using the product."

"We faced a challenge with deploying ClickHouse onto Kubernetes. Recently, we've been using ClickHouse Cloud, and the main issue is the high cost of the cloud service. The pricing isn't very competitive, especially for startups. I would instead buy a server and self-host if I have enough disk space. Besides that, ClickHouse has done very well, with clear goals and effective execution."

"ClickHouse is a user-friendly solution that tries to be compatible with SQL standards."

More ClickHouse pros

"The solution is scalable, it is very good."

"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."

"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."

"It's quite scalable."

"PostgreSQL is stable. It's available, stable, and reliable."

"The community support and the open-source community for it are good."

"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."

"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."

Cons

"If you join our team, it should be easy for you to use ClickHouse, especially if you are a developer. However, you need to read the documentation and understand the problems you are trying to solve."

"I would like ClickHouse to work more on integration with third-party tools."

"There aren't too many improvements I'd suggest for ClickHouse as it covers all my needs. There are just a few technical issues. For example, sometimes, when you want to get unique values and use certain tables, they don't work as expected. But it's not a major problem."

"We had a lot of troubles while deploying a whole cluster."

"ClickHouse has its own concept of database triggers and doesn't support traditional database triggers."

"There are some areas where ClickHouse could improve. Specifically, we encountered incompatibilities with its SQL syntax when migrating queries from MySQL or SQL to ClickHouse. This difference in details made it challenging to figure out the exact issues. Additionally, we faced difficulties due to the lack of a proper Django driver for ClickHouse, unlike MySQL, which Django supports out of the box."

"Initially, I faced challenges integrating ClickHouse, particularly with inserting data from ActiveMQ, which caused duplicates. However, after adjusting the ClickHouse settings, the issue was resolved and there were no more duplicates."

"One issue is that you need persistent volumes. Otherwise, if one system goes down, you lose data in that cluster."

More ClickHouse cons

"The scalability is limited."

"I had some issues when I integrated with the Jupyter Notebook."

"The solution could improve the integration."

"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."

"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."

"We have to set up event API, which takes a lot of events from the user."

"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."

"It needs more integration."

Pricing and Cost Advice

"The tool is free."

"We used the free, community version of ClickHouse."

"ClickHouse Cloud is not expensive compared to other databases, costing a few dollars per month while providing fast performance."

"For pricing, if you use the self-hosted version, it would be free. Cloud services pricing would be an eight out of ten. I try to minimize costs but still have to monitor usage."

"ClickHouse has an open-source version, which is free to use and has almost all the features."

"The tool is open-source."

"If you have an in-house deployment on Kubernetes or something, it's going to be very cheap since you'll be managing everything."

"Affordable solution."

"The community version of Postgre is basically free."

"It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it."

"It is an open-source platform."

"PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0."

"It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs."

"PostgreSQL is a free and open-source database."

"It is free. There is no license on it."

Top Industries

By visitors reading reviews

Computer Software Company

27%

Educational Organization

17%

Financial Services Firm

Manufacturing Company

Computer Software Company

16%

Financial Services Firm

12%

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What is your experience regarding pricing and costs for ClickHouse?

The tool is open-source.

See all answers

What needs improvement with ClickHouse?

There aren't too many improvements I'd suggest for ClickHouse as it covers all my needs. There are just a few technical issues. For example, sometimes, when you want to get unique values and use ce...

See all answers

What is your primary use case for ClickHouse?

I used ClickHouse to collect data, put it in the database, and then analyze it to find insights. The main advantage is that I can install it on my computer instead of using cloud-based solutions, s...

See all answers

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...

See all answers

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.

See all answers

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.

See all answers

Comparisons

OpenSearch vs ClickHouse

Compared 23% of the time

Milvus vs ClickHouse

Compared 16% of the time

SingleStore vs ClickHouse

Compared 13% of the time

Cassandra vs ClickHouse

Compared 10% of the time

MongoDB vs ClickHouse

Compared 5% of the time

More ClickHouse Competitors

Firebird SQL vs PostgreSQL

Compared 38% of the time

MySQL vs PostgreSQL

Compared 16% of the time

EDB Postgres Advanced Server vs PostgreSQL

Compared 14% of the time

MariaDB vs PostgreSQL

Compared 8% of the time

Product Reports

Buyer's Guide

ClickHouse

November 2024

Download ClickHouse product report

Buyer's Guide

PostgreSQL

November 2024

Download PostgreSQL product report

Learn More

ClickHouse

Video not available

PostgreSQL

Overview

ClickHouse is the fastest and most resource efficient open-source database for real-time apps and analytics.
ClickHouse supports all the data sources you need to power your apps and use cases that require exceptional performance.
ClickHouse uses all available system resources to their full potential to process each analytical query as fast as possible.
ClickHouse runs on every environment, whether it’s on your machine or in the cloud.

PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases.

It offers advanced features like indexing, replication, and transaction management. Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. Its robustness, scalability, and support for complex queries make it highly valuable.

Additionally, PostgreSQL's extensibility, flexibility, community support, and frequent updates contribute to its ongoing improvement and stability.

Sample Customers

Information Not Available

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

Buyer's Guide

ClickHouse vs. PostgreSQL

October 2024

Free Report: ClickHouse vs. PostgreSQL

Find out what your peers are saying about ClickHouse vs. PostgreSQL and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our ClickHouse vs. PostgreSQL report.

See our list of best Open Source Databases vendors and best Vector Databases vendors.

We monitor all Open Source 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.