PostHog Handbook Library / Engineering

67 words. Estimated reading time: 1 min.

# Overview

When designing a schema for ClickHouse, there are dozens of large and small decisions engineers need to make to design a well-performing solution fit for the problem being solved.

The following documents outline various schemas we have at PostHog, examining why they are designed this way, what are some good parts about them, and mistakes that were made.

### Schemas

- sharded_events
- app_metrics
- person_distinct_id

Canonical URL: https://posthog.com/handbook/engineering/clickhouse/schema

GitHub source: contents/handbook/engineering/clickhouse/schema/index.mdx

Content hash: `249806fb4d07dd6a`