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

How we made pivot tables three times faster

· · Oct. 21, 2026, 9:13 a.m.
engineering SQL Database Optimization Performance Improvement Pivot Tables
Summary
This blog post discusses improvements made to pivot table performance by utilizing new SQL features that allow querying the database for entire pivot tables in a single operation, thereby significantly reducing the need for multiple queries and the associated glue code.
Read full post on www.metabase.com →
MORE POSTS LIKE THIS
Making pivot tables faster with GROUPING SETS
metabase · Oct 21, 2026
engineering software development
Postgres relation files, filed under base/
Radim Marek · Oct 9, 2026
postgresql data storage
SkipScan in TimescaleDB: Why DISTINCT Was Slow, How We Built It, and How You Can Use It
Timescale · Sep 19, 2025
Announcements & Releases TimescaleDB
Beyond Query Optimization: Aurora Postgres Connection Pooling with SQLAlchemy & RDSProxy
Lyft · May 20, 2025
Connection Pooling aurora
Winning at the n-body benchmark
Fortran Lang Discourse · Nov 9, 2026
software development practices Performance Improvement
Workbench 0.9
Birchtree · Nov 7, 2026
Developer Tools user-interface-design
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.