The home for great developer writing.

We surface the best developer writing from thousands of independent blogs, updated daily.

SkipScan in TimescaleDB: Why DISTINCT Was Slow, How We Built It, and How You Can Use It

· Timescale · Sept. 19, 2025, 6:38 p.m.

Announcements & Releases TimescaleDB TimescaleDB Database Optimization Performance Improvement DISTINCT queries

Summary

TimescaleDB's SkipScan optimizes DISTINCT queries by reducing execution time from seconds to milliseconds through value-based jumping, greatly improving performance for developers.

Read full post on www.tigerdata.com →

MORE POSTS LIKE THIS

How we made pivot tables three times faster

metabase · Oct 21, 2026

engineering SQL

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Timescale · Jun 9, 2026

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

Intelligent Delivery: Making Every Unit of Compute Serve Better Ads

Facebook · Nov 11, 2026

ML Applications Machine Learning

Workbench 0.9

Birchtree · Nov 7, 2026

Developer Tools user-interface-design

Discover more posts →

AUTHOR