Introducing G2.ai, the future of software buying.Try now
Compare ClickHouse and PostgreSQL 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
RaimaDB
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ER/Studio
Visit Website
At a Glance
Market Segments
Small-Business (47.4% of reviews)
Small-Business (35.9% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
No pricing available
ClickHouse
Star Rating
(20)4.4 out of 5
Market Segments
Small-Business (47.4% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHousePostgreSQL
Star Rating
(663)4.4 out of 5
Market Segments
Small-Business (35.9% of reviews)
Entry-Level Pricing
No pricing available
Learn more about PostgreSQLSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that PostgreSQL excels in data modeling with a score of 9.4, making it a preferred choice for complex data structures, while ClickHouse, although strong, has a slightly lower score of 9.0 in this area.
- Reviewers mention that PostgreSQL's ACID compliance is rated at 9.0, ensuring reliable transactions, whereas ClickHouse, while performant, does not fully support ACID transactions, which can be a concern for users needing strict data integrity.
- G2 users highlight that ClickHouse shines in query performance, particularly for analytical workloads, with a focus on lower query latency and faster ingestion, making it ideal for real-time analytics, while PostgreSQL is more suited for transactional workloads.
- Users on G2 report that PostgreSQL has a robust backup and recovery system rated at 7.8, but ClickHouse's backup capabilities are less emphasized, which could be a drawback for users prioritizing data recovery options.
- Reviewers say that PostgreSQL's quality of support is rated at 7.9, which some users find lacking compared to ClickHouse's higher support rating of 8.5, indicating a more responsive support experience for ClickHouse users.
- Users say that PostgreSQL's multi-user environment is rated at 8.1, which can be limiting in high-concurrency scenarios, while ClickHouse's architecture is designed for high concurrency, making it more suitable for environments with many simultaneous users.
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
8.9
11
9.1
543
Ease of Use
8.6
11
8.5
548
Ease of Setup
9.0
7
8.4
277
Ease of Admin
7.0
5
8.2
249
Quality of Support
8.7
9
7.9
439
Has the product been a good partner in doing business?
Not enough data
8.4
198
Product Direction (% positive)
10.0
10
8.5
530
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
121
9.3
5
9.1
119
Feature Not Available
9.1
107
Not enough data
8.9
110
Support
Not enough data
8.6
113
Not enough data
9.2
123
Not enough data
9.1
110
Not enough data
9.1
112
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
112
Not enough data
8.6
106
Not enough data
8.8
111
Not enough data
8.6
109
Database Features
9.0
5
9.0
460
9.3
5
9.0
465
9.0
5
9.0
468
9.0
5
8.6
450
Not enough data
8.7
439
Not enough data
8.8
453
8.7
5
9.0
460
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
31.6%
Computer Software
21.1%
Wholesale
5.3%
Telecommunications
5.3%
Marketing and Advertising
5.3%
Other
31.6%
Information Technology and Services
27.3%
Computer Software
23.1%
Internet
4.3%
Financial Services
4.1%
Telecommunications
2.9%
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.
