[HN Gopher] How ClickHouse saved our data (2020)
       ___________________________________________________________________
        
       How ClickHouse saved our data (2020)
        
       Author : mmcclure
       Score  : 17 points
       Date   : 2021-02-18 16:40 UTC (6 hours ago)
        
 (HTM) web link (mux.com)
 (TXT) w3m dump (mux.com)
        
       | wiredfool wrote:
       | I've also had some pretty clear successes moving a ~2TB Postgres
       | database into a 70GB Clickhouse instance, (though, in this case a
       | good 2/3 of the issue was scheme design on the PG side, but there
       | were still another order of magnitude compression to be had from
       | clickhouse.)
       | 
       | Queries went from a 12 hour table scan to ~2 minutes, and
       | production queries from 45 sec to 400ms.
       | 
       | This is without doing anything particularly tricky on the
       | clickhouse side, nor even putting it on a particularly large
       | machine. When benchmarking it, I put it on a 10yr old laptop, and
       | I was seeing production queries in the seconds range,
        
       ___________________________________________________________________
       (page generated 2021-02-18 23:00 UTC)