[darkbatman]

We do quite similar but through Debezium/Kafka CDC pipeline to clickhouse. This way primary database is protected. Directly querying from files from postgres might get slower eventually IMO compare.

[exAspArk]

This is a great DIY setup. We're hoping to compress this stack and simplify it down to a single binary