Show HN: Straum – PostgreSQL Group by in Microseconds

  • Posted 1 hour ago by jeeybee
  • 2 points
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.

What do you think?

Benchmark: https://janbjorge.github.io/straum/benchmark.html Repo: https://github.com/janbjorge/straum

0 comments