Lower resource usage of ClickHouse in the default configuration - Githubissues

plausible / community-edition

Example Docker Compose setup for hosting Plausible Community Edition

1.45k stars 304 forks source link

Lower resource usage of ClickHouse in the default configuration #185

Open ruslandoga opened 1 week ago

ruslandoga commented 1 week ago

Collecting some ideas for now:

ttl_only_drop_parts = 1 on tables with TTL (do we even have them, logs maybe?)
https://github.com/plausible/analytics/discussions/4740#discussioncomment-11074630

salomvary commented 5 days ago

Do everything recommended in https://clickhouse.com/docs/en/operations/tips#using-less-than-16gb-of-ram?