![What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data? What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data?](https://www.timescale.com/blog/content/images/2021/10/03-query-latency.jpg)
What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data?
![Using partitions in Clickhouse. Clickhouse supports table partitioning… | by Denys Golotiuk | DataDenys | Medium Using partitions in Clickhouse. Clickhouse supports table partitioning… | by Denys Golotiuk | DataDenys | Medium](https://miro.medium.com/v2/resize:fit:1218/1*v1SYW2M4VdUZd5Puvx0lbg.png)
Using partitions in Clickhouse. Clickhouse supports table partitioning… | by Denys Golotiuk | DataDenys | Medium
![Full name column appears in left join of multiple tables · Issue #28121 · ClickHouse/ClickHouse · GitHub Full name column appears in left join of multiple tables · Issue #28121 · ClickHouse/ClickHouse · GitHub](https://user-images.githubusercontent.com/74392381/130733049-68b1555c-e124-4944-a3e2-b4cc0166ae23.png)
Full name column appears in left join of multiple tables · Issue #28121 · ClickHouse/ClickHouse · GitHub
![In a table, 20,000 columns were created, and then when Insert, an exception was reported. How many columns can you support in the largest table? · Issue #6943 · ClickHouse/ClickHouse · GitHub In a table, 20,000 columns were created, and then when Insert, an exception was reported. How many columns can you support in the largest table? · Issue #6943 · ClickHouse/ClickHouse · GitHub](https://user-images.githubusercontent.com/55344414/64918867-a2741300-d7d6-11e9-89c6-85bf25e47329.png)