[HN Gopher] Postgres to ClickHouse: Data Modeling Tips
       ___________________________________________________________________
        
       Postgres to ClickHouse: Data Modeling Tips
        
       Author : saisrirampur
       Score  : 25 points
       Date   : 2025-07-19 17:24 UTC (5 hours ago)
        
 (HTM) web link (clickhouse.com)
 (TXT) w3m dump (clickhouse.com)
        
       | benwilson-512 wrote:
       | We have been doing exactly this at CargoSense! We have gotten
       | very far on just Postgres but as our BI and other analytics
       | queries have gotten more complex and our scale of "business
       | tables" grown 20x over the last 18 months it just wasn't cutting
       | it anymore.
       | 
       | The CDC to Clickhouse flow has been very fast and reliable, and
       | then for us at least setting up some incremental materialized
       | views that set up what we need for reporting has been perfect.
       | Clickhouse's storage efficiency has been mind boggling.
        
       ___________________________________________________________________
       (page generated 2025-07-19 23:01 UTC)