3 ms·

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

• I_am_tiberius 1y ago
  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.
  • jacobsenscott 1y ago
    CH excels at extremely high volume writes. You probably can't throw enough data at it.
    • I_am_tiberius 1y ago
      Sorry, meant writes in terms of update/delete.
      • hodgesrm 1y ago
        There are many use cases that do not alter data. Observability is a canonical example.
      • nasretdinov 1y ago
        Many use cases can be addressed by using ReplacingMergeTree and such, so even when you need updates you can get them relatively cheaply