For my use case of something similar on Clickhouse: We load data from postgres tables that are used to build Clickhouse Dictionaries (a hash table for JOIN-ish

For my use case of something similar on Clickhouse: We load data from postgres tables that are used to build Clickhouse Dictionaries (a hash table for JOIN-ish operations). The big tables do not arrive via real-time-ish sync from postgres but are bulk-appended using a separate infrastructure.