v.25.4Performance Improvement
Introduce a setting schema_type
Introduce a settingschema_typeforsystem.metric_logtable with schema type. There are three allowed schemas:wide-- current schema, each metric/event in a separate column (most effective for reads of separate columns),transposed-- similar tosystem.asynchronous_metric_log, metrics/events are stored as rows, and the most interestingtransposed_with_wide_view-- create underlying table withtransposedschema, but also introduce a view withwideschema which translates queries to underlying table. Intransposed_with_wide_viewsubsecond resolution for view is not supported,event_time_microsecondsis just an alias for backward compatibility. #78412 (alesapin).