DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About Privacy
Sign up
Topics
Follow your own topics →
Menu
New Following Discover Jobs Top Writers
More
Suggest a blog Upvotes plugin Report bug Contact About
Sign up
Privacy Policy
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS

Postgres Sorting at Scale Needs More Than ORDER BY

· Timescale · June 24, 2026, 1:23 p.m.
postgresql Postgres time-series-data Database Optimization 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
The Top 10 SQL Server Wait Types, Worldwide
Brentozar · Nov 4, 2026
Wait Stats sql-server
Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows
Timescale · Aug 28, 2026
time-series-data postgresql
How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
Hakibenita · Jul 9, 2026
articles postgresql
Hacking the Postgres Statistics Tables for Faster Queries
Crunchy Data · Apr 16, 2025
Production Postgres software development
Missing indexes are slowing down your database - here's how to find and fix them with Sentry
Sentry · Dec 9, 2024
user-experience development-practices
Data Access Testing With @testcontainers
Frontendmasters · Nov 4, 2026
blog-post database
Discover more posts →
AUTHOR
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub Continue with Google
By continuing, you agree to our Privacy Policy.