Subchapter 4.27

Schema Partition Start Without

rules/schema-partition-start-without.mdMarkdown1 KBView on GitHub

Consider Starting Without Partitioning

Impact: MEDIUM

Start without partitioning and add it later only if:

You have clear data lifecycle requirements (retention, archiving)

Schema Partition Start Without · Clickhouse Best Practices · ClickHouse/agent-skills · Skills Docs

-- Start simple, no partitioning
CREATE TABLE events (
    timestamp DateTime,
    event_type LowCardinality(String),
    user_id UInt64
)
ENGINE = MergeTree()
ORDER BY (event_type, timestamp);

-- Add partitioning later if needed for lifecycle management
-- (requires table recreation or materialized view migration)

Need	Add Partitioning?
Time-based data retention	Yes
Archive old data to cold storage	Yes
Query performance on time ranges	Maybe (test first)
No specific lifecycle needs	No