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.
This is a great DIY setup. We're hoping to compress this stack and simplify it down to a single binary
This is a great DIY setup. We're hoping to compress this stack and simplify it down to a single binary