Skip to content
Standard Reader
Log in
Tag

Clickhouse

Articles and publications tagged Clickhouse across the Atmosphere.

13articles2publications
sorrelthorncroft
sorrelthorncroftOct 28, 2026
127,120 ClickHouse Fingerprints and the Default User Behind Them
The analytics engine uses a user named default when none is specified. Whether that user has a password is a configuration choice, and one worth checking.
clickhouseanalytics
PostHog Blog
PostHog BlogMay 1, 2026
DuckDB vs ClickHouse: Why we use both at PostHog
ClickHouse and DuckDB are two heavyweights in the OLAP category. This makes them appear as direct competitors. In a few respects they are, but they are essentially tangential products that have garnered popularity in the OLAP world for separate…
ExplainersClickHouse
PostHog Blog
PostHog BlogJun 30, 2023
In-depth: ClickHouse vs Redshift
We've written extensively comparing ClickHouse to other analytical databases, including Google BigQuery , Elastic , and Apache Druid . Most of those articles had the same gist – a tuned ClickHouse instance is faster by many orders of magnitude…
ExplainersClickHouse
PostHog Blog
PostHog BlogJun 12, 2023
Introducing HouseWatch: An open-source toolkit for ClickHouse
We are big fans of ClickHouse. We rely on it heavily to store and retrieve the massive amount of data we process every day. In doing this at scale for multiple years now, we’ve built a lot of expertise and systems related to ClickHouse. To formalize…
Product updatesRelease notes
PostHog Blog
PostHog BlogApr 24, 2023
In-depth: ClickHouse vs BigQuery
Both BigQuery and ClickHouse are databases designed to handle lots of data (like loads of data), but they have distinct philosophies and use cases. BigQuery is exceptional at handling complex business queries that can tolerate many-second…
GuidesClickHouse
PostHog Blog
PostHog BlogMar 20, 2023
In-depth: ClickHouse vs Elasticsearch
Elasticsearch and ClickHouse are both open-source frameworks with advantages over conventional databases like PostgreSQL for performing tasks over lots of data, but they serve very different needs. Elasticsearch, as the name implies, was designed…
ExplainersClickHouse
PostHog Blog
PostHog BlogFeb 15, 2023
In-depth: ClickHouse vs Snowflake
Two years ago, Snowflake versus ClickHouse was a straightforward comparison. Back then, Snowflake was fully managed, expensive, and broadly featured. ClickHouse was on-prem, open source, and speed-optimized. Two ends of a data warehouse spectrum…
GuidesClickHouse
PostHog Blog
PostHog BlogJan 13, 2023
In-depth: ClickHouse vs Druid
Contrary to what the names might suggest, ClickHouse isn’t an TikTok influencer house and Druid isn’t (just) a D&D character class – they're both modern online analytical processing (OLAP) databases designed to store and retrieve lots of data fast…
ExplainersClickHouse
PostHog Blog
PostHog BlogOct 28, 2022
In-depth: ClickHouse vs PostgreSQL
Honestly, it is a bit ridiculous to compare Postgres and ClickHouse. The two database solutions are as similar as grapes and grapefruit. ClickHouse was created for a specific purpose; PostgreSQL (aka Postgres) was designed to be flexible and all…
GuidesClickHouse
PostHog Blog
PostHog BlogMar 18, 2022
Enabling zero downtime data migrations for self-hosted users
In this world nothing is certain except death, taxes, and database migrations. As your product evolves, your schemas evolve too, and you need migrations to update them. However, not all migrations are made equal. Some are simple, others are complex…
ClickHouseProduct updates
PostHog Blog
PostHog BlogNov 6, 2021
How we turned ClickHouse into our event mansion
Recently, PostHog was invited to speak at OSA Con 2021 , an open source analytics conference organised by Altinity. It was a fantastic opportunity to talk to the community, alongside other engineers and leaders from projects such as ClickHouse…
ClickHouse
PostHog Blog
PostHog BlogOct 26, 2021
How to speed up ClickHouse queries using materialized columns
ClickHouse supports speeding up queries using materialized columns to create new columns on the fly from existing data. In this post, I’ll walk through a query optimization example that's well-suited to this rarely-used feature. Consider the…
GuidesClickHouse
PostHog Blog
PostHog BlogAug 20, 2021
We just made PostHog Open Source 1000x more scalable via ClickHouse
We're excited to announce a major under-the-hood upgrade for PostHog Open Source! Over the past few weeks, our team have been hard at work moving over from Postgres to ClickHouse, the same database that powers PostHog Cloud. This means you can now…
Product updatesClickHouse

You've reached the end.