News for hackers. Stuff that matters.

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.