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

Date updated

Mar 12, 2025

Share

Subscribe to the Timescale Newsletter

By submitting you acknowledge Timescale's Privacy Policy.