#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Sign up
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join now
→
Learn more
TOPICS
Postgres Sorting at Scale Needs More Than ORDER BY
113
·
Timescale
·
June 24, 2026, 1:23 p.m.
postgresql
Postgres
Database Optimization
time-series-data
query performance
Summary
This blog post discusses the challenges of sorting time-series data using Postgres and presents solutions such as time_bucket and continuous aggregates to drastically reduce query times.
Read full post on www.tigerdata.com →
MORE POSTS LIKE THIS
How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
Hakibenita ·
Jul 9, 2026
articles
postgresql
Six Signs That Postgres Tuning Won't Fix Your Performance Problems
Timescale ·
Feb 12, 2026
postgresql
Postgres
Hacking the Postgres Statistics Tables for Faster Queries
Crunchy Data ·
Apr 16, 2025
Production Postgres
postgresql
Missing indexes are slowing down your database - here's how to find and fix them with Sentry
Sentry ·
Dec 9, 2024
Database Optimization
Performance Tuning
The Big Interview: Cockroach Labs CEO Spencer Kimball
Thestack ·
Jul 23, 2026
Big Interview
Databases
Time-Series Magic: The Polars join_asof (Merging Non-Exact Times)
Ahmed Nabil ·
Jul 20, 2026
Data Science
2026
Discover more posts →
AUTHOR
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub
Continue with Google