[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)