Compare ClickHouse and PostgreSQL 
Featured Products
At a Glance
Market Segments
Small-Business (50.0% of reviews)
Small-Business (35.8% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
No pricing available
ClickHouse
Star Rating
(21)4.4 out of 5
Market Segments
Small-Business (50.0% of reviews)
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHousePostgreSQL
Star Rating
(671)4.4 out of 5
Market Segments
Small-Business (35.8% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about PostgreSQLSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- G2 reviewers report that PostgreSQL excels in reliability and data integrity, with users praising its robust ACID compliance and the ability to handle complex SQL queries effectively. One user noted, "What truly distinguishes PostgreSQL for me is its reliability and data integrity," highlighting its performance in production environments.
- Users say ClickHouse stands out for its exceptional query performance, especially with large datasets. Reviewers have mentioned that it makes analytics "lightning-fast and efficient," which is a significant advantage for real-time analytics workloads.
- According to verified reviews, PostgreSQL is favored for its customizability and scalability, allowing users to run it on minimal hardware configurations. One user remarked, "We can rely on it for scalability and ease of use, which saves a lot of money on database infrastructure."
- Reviewers mention that ClickHouse's columnar storage design optimizes both storage and computation, making it particularly effective for analytics. Users appreciate its ability to query millions of rows in seconds, stating, "The best tool for querying millions of rows in one second."
- G2 reviewers highlight that while PostgreSQL has a strong overall user satisfaction score, it faces challenges in administration ease, with some users finding it less intuitive compared to ClickHouse. One user noted, "The ease of admin could be improved," indicating room for enhancement in this area.
- Users report that ClickHouse offers a cost-effective solution for analytics, with a starting price of just $1.00, making it accessible for small businesses. This affordability, combined with its performance, makes it an attractive option for those looking to optimize their database costs.
Pricing
Entry-Level Pricing
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
PostgreSQL
No pricing availableFree Trial
ClickHouse
No trial information availablePostgreSQL
No trial information availableRatings
Meets Requirements
9.0
12
9.1
548
Ease of Use
8.8
12
8.5
553
Ease of Setup
9.2
8
8.4
282
Ease of Admin
7.0
5
8.2
251
Quality of Support
8.5
10
7.9
443
Has the product been a good partner in doing business?
Not enough data
8.5
199
Product Direction (% positive)
10.0
11
8.5
535
Features by Category
Management
9.4
6
Not enough data
7.9
7
Not enough data
9.3
7
Not enough data
9.4
6
Not enough data
10.0
5
Not enough data
Maintenance
8.8
7
Not enough data
7.8
6
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Management
Not enough data
9.1
122
9.3
5
9.1
120
Feature Not Available
9.1
109
Not enough data
8.9
111
Support
Not enough data
8.6
113
Not enough data
9.2
127
Not enough data
9.1
111
Not enough data
9.1
113
Security
Feature Not Available
8.7
114
Not enough data
8.9
116
Not enough data
8.6
108
Not enough data
8.9
110
Performance
Not enough data
8.6
106
Not enough data
8.8
114
Not enough data
8.6
108
Not enough data
8.8
113
Not enough data
8.6
111
Database Features
9.0
5
9.0
460
9.3
5
9.0
465
9.0
5
9.0
472
9.0
5
8.6
454
Not enough data
8.7
440
Not enough data
8.8
453
8.7
5
9.0
462
Storage
9.2
6
Not enough data
9.0
7
Not enough data
Availability
Feature Not Available
Not enough data
7.8
6
Not enough data
8.3
6
Not enough data
Performance
8.1
6
Not enough data
Security
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.3
5
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
ClickHouse and PostgreSQL are categorized as Relational Databases
Unique Categories
ClickHouse is categorized as Real-time Analytic Database, Database Management Systems (DBMS), and Columnar Databases
PostgreSQL has no unique categories
Reviews
Reviewers' Company Size
ClickHouse
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
PostgreSQL
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.0%
Computer Software
20.0%
Wholesale
5.0%
Telecommunications
5.0%
Marketing and Advertising
5.0%
Other
30.0%
Information Technology and Services
27.5%
Computer Software
22.9%
Internet
4.3%
Financial Services
4.1%
Telecommunications
2.8%
Other
38.3%
Alternatives
Discussions
ClickHouse has no discussions with answers
What are the advantages and disadvantages of PostgreSQL?
2 Comments
AG
Open Source: PostgreSQL is free and open-source software, meaning anyone can download, use, and modify it as needed without licensing costs.
SQL...Read more
Can we get some video tutorials on usage? Also how do we connect them over cloud ?
1 Comment
NH
Hey Jay,
We use Postgresql on all of our cloud servers. We connect via SSL connections to the specific...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
