Topics
Follow your own topics →
DIFF.BLOG
New Following Discover Jobs
More
Top Writers Suggest a blog Upvotes plugin
Report bug Contact About
Sign up
Menu
New Following Discover Jobs Top Writers
More
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