Sayed Alesawy
How to Use ClickHouse Aggregation States to Boost Materialized Views Performance by More Than 10 Times?

How to Use ClickHouse Aggregation States to Boost Materialized Views Performance by More Than 10 Times?

In this article, I will discuss how to use Aggregation States in ClickHouse to boost Materialized Views performance by orders of magnitude. We will be building a small project along the way to show how all different optimizations can work together to...

Sayed Alesawy
Sayed Alesawy
19 min read
Designing Data Intensive Applications: Ch.7 Transactions (weak isolation levels)

Designing Data Intensive Applications: Ch.7 Transactions (weak isolation levels)

Sayed Alesawy
Sayed Alesawy
22 min read
Designing Data Intensive Applications: Ch.7 Transactions (intro to ACID transactions)

Designing Data Intensive Applications: Ch.7 Transactions (intro to ACID transactions)

Sayed Alesawy
Sayed Alesawy
7 min read
Sayed Alesawy

Sayed Alesawy

737 followers

Lead Software Engineer at Instabug | Backend. Passionate about large scale server side applications and distributed systems.

Designing Data Intensive Applications: Ch.6 Partitioning (Part 3: Rebalancing Partitions and Request Routing)

Designing Data Intensive Applications: Ch.6 Partitioning (Part 3: Rebalancing Partitions and Request Routing)

Sayed Alesawy
10 min read
Designing Data Intensive Applications: Ch.6 Partitioning (Part 2: Partitioning and Secondary Indexes)

Designing Data Intensive Applications: Ch.6 Partitioning (Part 2: Partitioning and Secondary Indexes)

Sayed Alesawy
5 min read
Designing Data Intensive Applications: Ch.6 Partitioning (Part 1: Partitioning of Key-Value Data)

Designing Data Intensive Applications: Ch.6 Partitioning (Part 1: Partitioning of Key-Value Data)

Sayed Alesawy
10 min read
How to implement Efficient Point Queries in ClickHouse?

How to implement Efficient Point Queries in ClickHouse?

Sayed Alesawy
10 min read
Designing Data Intensive Applications: Ch5. Replication (Part 4: Leaderless Replication)

Designing Data Intensive Applications: Ch5. Replication (Part 4: Leaderless Replication)

Sayed Alesawy
11 min read
Designing Data Intensive Applications: Ch5. Replication (Part 3: Multi-Leader Replication)

Designing Data Intensive Applications: Ch5. Replication (Part 3: Multi-Leader Replication)

Sayed Alesawy
14 min read
Designing Data Intensive Applications: Ch5. Replication (Part 2: Problems with Replication Lag)

Designing Data Intensive Applications: Ch5. Replication (Part 2: Problems with Replication Lag)

Sayed Alesawy
11 min read
Designing Data Intensive Applications: Ch5. Replication (Part 1: Leader-Based Replication)

Designing Data Intensive Applications: Ch5. Replication (Part 1: Leader-Based Replication)

Sayed Alesawy
16 min read
Designing Data Intensive Applications: Ch4. Encoding and Evolution

Designing Data Intensive Applications: Ch4. Encoding and Evolution

Sayed Alesawy
8 min read