Show HN: Straum – a Postgres materialized view that is never stale
https://github.com/janbjorge/straum
I've seen too many slow-log queries with a GROUP BY that makes Postgres blow up, so for the last two weeks or so I've been working on Straum. You declare the aggregates as a view, and Straum answers over HTTP (other transports might be added). I've been using the New York taxi dataset as a benchmark. On the heavier GROUP BYs I see about 1,000x to 5,000x. It's written in Rust (of course).It leans on Postgres replication slots, logical or physical, to get its data. Postgres stays the source of truth.
Benchmark: https://janbjorge.github.io/straum/benchmark.html Repo: https://github.com/janbjorge/straum
(
no comments
| on HN
)
There are no comments yet.