Hacker News new | ask | show | jobs
by yen223 401 days ago
I have participated in a Postgres -> Clickhouse migration, but I haven't bothered writing an article about it.
1 comments

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.
Many use cases can be addressed by using ReplacingMergeTree and such, so even when you need updates you can get them relatively cheaply
There are many use cases that do not alter data. Observability is a canonical example.