Hacker News Reader

I have participated in a Postgres -> Clickhouse migration, but I haven't bothered writing an article about it.

The entire database? Isn't that very limiting due to slow write speeds in Clickhouse? I saw ch more as a db for mainly read activities.

CH excels at extremely high volume writes. You probably can't throw enough data at it.

Sorry, meant writes in terms of update/delete.

There are many use cases that do not alter data. Observability is a canonical example.

Many use cases can be addressed by using ReplacingMergeTree and such, so even when you need updates you can get them relatively cheaply