TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

SkipScan Under Load

8 pointsby jamesgresql7 months ago

1 comment

jamesgresql7 months ago
Hi HN!<p>I wrote this article comparing TimescaleDB&#x27;s SkipScan feature to vanilla Postgres performance for DISTINCT queries (get me the last row for all IDs) while a 200K rows per second ingest was happening.<p>I&#x27;m going to be writing more of these smaller performance pieces (sometimes Timescale related, sometimes Postgres related) - I&#x27;d love to hear some suggestions (especially around PG performance) from the HN community