PostgreSQL

Mar 12, 2025

PostgreSQL DISTINCT: TimescaleDB’s SkipScan Under Load

Hi, I'm James. I work in Developer Advocacy at Timescale. Recently, I’ve been diving deep into performance topics and thinking about the kind of content I enjoy reading and writing. This is a new series that will focus on using data visualizations to spotlight single concepts in Timescale or PostgreSQL performance. No marketing fluff, no unrealistic benchmarks, just straightforward explorations of performance topics I find interesting, with some notes on why I think they matter.

<span style="white-space: pre-wrap;">A graph benchmarking the DISTINCT query response times with SkipScan vs vanilla PostgreSQL</span>
A graph benchmarking the DISTINCT query response times with SkipScan vs vanilla PostgreSQL

Originally posted

Nov 07, 2024

Last updated

Mar 12, 2025

Share

Subscribe to the Timescale Newsletter

By submitting you acknowledge Timescale's Privacy Policy.