#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Privacy
Sign up
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
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
Lakebase Search: State-of-the-art full text and vector search for Postgres
Mooncake ·
Sep 28, 2026
Lakebase
database
Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.
Brentozar ·
Sep 22, 2026
Database Animations
indexing
Discover more posts →
AUTHOR
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →
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
.