Why Database Time Series Storage Uses Chunked Archives
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations Hosted by Fexingo
In this episode of Database Tech with Fexingo, Lucas and Luna dig into the design of time-series databases and the chunked archive pattern that underpins systems like InfluxDB, Prometheus, and TimescaleDB. They explain why a flat table of timestamped rows performs poorly at scale, how chunking data by time interval improves write throughput and query speed, and how compression and retention policies become far simpler when data is organized in time-based blocks. The conversation anchors on a real-world example: a smart-meter deployment generating millions of readings per day, and why the database that handles it uses chunked archives rather than a traditional relational model. Along the way, they touch on downsampling, tiered storage, and the trade-off between write amplification and query granularity. A practical, example-driven look at why time-series databases structure data the way they do, and how that affects performance and cost. #TimeSeriesDatabase #ChunkedArchive #InfluxDB #Prometheus #TimescaleDB #IoTData #DatabaseDesign #DataCompression #RetentionPolicy #Downsampling #WriteThroughput #QueryPerformance #DatabaseStorage #TechPodcast #DataEngineering #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.