1 min readfrom InfoQ

Article: Time-Series Storage: Design Choices That Shape Cost and Performance

Article: Time-Series Storage: Design Choices That Shape Cost and Performance

Every time-series database makes a set of storage design decisions: how to lay out rows, when to compress, what to partition on. These decisions determine cost and query performance more than the choice of database itself. This article works through those fundamentals from first principles, using widely available tools like PostgreSQL and Apache Parquet to make each trade-off measurable.

By Nirmesh Khandelwal

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#real-time data collaboration
#real-time collaboration
#big data performance
#rows.com
#self-service analytics tools
#business intelligence tools
#collaborative spreadsheet tools
#data visualization tools
#data analysis tools
#time-series database
#query performance
#storage design
#cost
#compression
#partitioning
#Apache Parquet
#PostgreSQL
#data storage
#trade-off
#design decisions