Normalized vs flat DB schema in ClickHouse world.

[Eugene Gordon]

Hi,

We have DB with few tables each having structure like:

<common_column><specific_table_columns><row_score> .

We started with 2 tables and adding 2-3 month one table.
This normalized like DB works well for DB like Postgress till
we hit some performance issues. Each table has few million rows and is growing
once per day.

We plan to switch DB to ClickHouse.
What is advice/common_practice - switch to one big flat table or stick
to what we have i.e. normalized like?

Thanks,

Eugene

[Alexey Milovidov]

A flat table is preferred, even if many columns will be sparse.

> --
> You received this message because you are subscribed to the Google Groups "ClickHouse" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to clickhouse+...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/3b2e40b2-e386-4267-a6fb-ec9f4d884ba1n%40googlegroups.com.