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

Our AI agent doesn't care about slow code

Mathias Haugsbø · Oct 20, 2026

AI in software development Code Optimization

Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.

Brentozar · Oct 21, 2026

First responder kit Database Optimization

We Got Early Access to NVIDIA Nemotron 3.5 Embed. It's Hindsight's New Top Embedding Model.

Hindsight Blog · Oct 21, 2026

hindsight Agent Memory

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 →