I wrote this article comparing TimescaleDB'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.
I'm going to be writing more of these smaller performance pieces (sometimes Timescale related, sometimes Postgres related) - I'd love to hear some suggestions (especially around PG performance) from the HN community
1 comment
[ 228 ms ] story [ 2975 ms ] threadI wrote this article comparing TimescaleDB'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.
I'm going to be writing more of these smaller performance pieces (sometimes Timescale related, sometimes Postgres related) - I'd love to hear some suggestions (especially around PG performance) from the HN community