Home / Companies / ClickHouse / Blog / Post Details
Content Deep Dive

What else runs on your Postgres server, and how do we stop it from taking the database down?

Blog post from ClickHouse

Post Details
Company
Date Published
Author
-
Word Count
890
Company Posts That Month
23
Language
English
Hacker News Points
-
Post removed?
No
Summary

ClickHouse Managed Postgres treats supporting services such as connection poolers, backup agents, metrics exporters, Prometheus, log collectors, and watchdogs as part of the database failure model because their resource consumption can impair PostgreSQL availability. While PostgreSQL shared buffers are protected through boot-reserved huge pages, other database memory needs share system capacity with auxiliary processes, so supporting Go services are grouped in a cgroup v2 slice with GOMEMLIMIT runtime targets, memory.high pressure controls, and memory.max hard limits to contain leaks and ensure any cgroup OOM event does not select PostgreSQL processes. Resource controls also extend to reduced CPU weights for backups, fixed backup buffer sizes, log collector memory limits, curated metric exports to prevent high cardinality, disk thresholds, and session termination during disk-full emergencies. The disk watchdog preserves replication and monitoring users while ending ordinary application sessions, aiming to maintain recovery and observability functions under pressure. These default controls isolate supporting workloads while keeping backup, replication, monitoring, and PostgreSQL within defined resource budgets.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.