If you have something like Kafka before you insert your events into CH, you could consider enriching the event data by connecting with your Postgres data. That way, you still retain a flat CH table which should work just fine.
Wonderful effort folks. You are definitely creating something that's going to last a long time and help a lot of people. Zerodha is a company I will adore from now on.