4 ms·

I looked into Clickhouse for OLAP. Our main database would be PostgreSQL unfortunatly their MaterializedPostgresql does not support TOAST, which is a major down

by merb 5y ago

I looked into Clickhouse for OLAP. Our main database would be PostgreSQL unfortunatly their MaterializedPostgresql does not support TOAST, which is a major downside, considering we are TEXT/JSONB heavy users. Edit: I tested it but for some reason either the docs are strange or wrong. but TOAST tables are actually replicated?! or at least I see the data?

jordanthoms 5y ago
TEXT/JSONB are stored inline IIRC unless they hit a certain size limit at which point they'll be put into TOAST - so you'll see data in clickhouse but some big values might be missing.
- merb 5y ago
  do you know if it will in the future? or is this a clickhouse limit of their string data type?
  - qoega 5y ago
    ClickHouse has no limit on sting data length. MaterializedPostgreSQL engine is just very recent feature with not large adoption rate. I believe if community will use it frequently it will become more bulletproof and more edge cases will be supported. TOAST in replication protocol is just not trivial to implement.