Insert compressed protobufs or insert blocks with LZ4 compression

[romesful]

I want to insert in Protobuf format, compressed in LZ4. There is a lot of data, now clickhouse-cpp client is used with compression enabled, sending TBlock's. I want to make up protobuffs and compress them, is this option really better than the current one? What are pros and cons?

[avinzhang]

Choosing between compressed Protobufs and LZ4 compression depends on your specific use case:

• Use compressed Protobufs if you need efficient data serialization, schema evolution, and integration with other systems using Protobuf.

• Use LZ4 compression if you prefer ClickHouse's native block compression for its speed and simplicity, and you want to optimize storage and performance without additional serialization steps.