Advanced PostgreSQL: Partitioning vs Sharding for Time-Series Data

Nisha Agarwal Database Management Sep 11, 2025 08:51 PM

179

Views

Managing 50TB+ time-series data with PostgreSQL. Evaluating table partitioning vs horizontal sharding. Current setup uses monthly partitions but query performance degrading. Need insights on CitusDB vs manual sharding.

Replies (0)

No replies yet. Be the first to reply!

Add Your Reply

Similar Discussions

Advanced SQL Optimization: Query Plan Analysis

4 months ago

Dealing with complex analytical queries on 100TB+ datasets. Current bottlenecks in join operations a...

0 replies 178 views

Advanced SQL Optimization: Query Plan Analysis

5 months ago

Dealing with complex analytical queries on 100TB+ datasets. Current bottlenecks in join operations a...

0 replies 180 views

Advanced PostgreSQL: Partitioning vs Sharding for Time-Serie...

5 months ago

Managing 50TB+ time-series data with PostgreSQL. Evaluating table partitioning vs horizontal shardin...

0 replies 177 views