Hacker News Reader

Have you tried the PostgreSQL table engine?

Or Debezium to Kafka for a more hand coded solution?

The materialized postgres is still experimental and has some backlog until being production ready.

Debezium -> kafka -> kafka engine -> MVs -> Replacing merge trees works like a charm for me.