interesting advice: monitor how often ClickHouse crashes with segfaults. Doesn't sound like production grade quality product.
I don't think is going to happen often, but definitely happens. We see that more than anyone would do because we run a lot of different workload types, any possible combination of types/sql/engines...
Running postgres in my previous company we saw a few of them as well and I'd consider postgres a "production grade" system.