1
How percentile approximation works and why it's more useful than averages
What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.
The latest thoughts, tutorials, and technical posts on TimescaleDB, Postgres, AI and time series. With use cases ranging from IoT to crypto, real-time analytics, and more.
Visit blog.timescale.com → On Hacker News Apr 2017 – Oct 2021
Databases & Data 21Tech Industry & Business 7Systems & Performance 5Open Source 4Software Engineering 2Math & Algorithms 2
What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.
Learn how time-weighted averages are calculated and why they’re so powerful for data analysis. Read the full article on the Tiger Data blog.