Learn more about data modeling and the underlying data storage when using Timescale hypertables. In this blog post, we cover the three main table design options and explain why and how you should use them.

PostgreSQL insights for every developer journey. Get tips and tutorials on database performance, query optimization, time-series data, and more—from real-time analytics and IoT data management to events and vector embeddings. 


TigerData (Creators of TimescaleDB)

Time-series applications are designed to store massive amounts of time-related information. Data modeling the underlying data storage when you have one or more Timescale hypertables is essential. Since Timescale is built upon a relational database model, there are a few ways you can design our hypertables.

Best Practices for Time-Series Modeling

Time-Series Data Modeling: What Are the Different Table Layouts?

Hypertable Compression (Compressed Chunks)