Introducing Scheduled Upgrades in ClickHouse Managed Postgres

Summary

ClickHouse Managed Postgres now supports scheduled maintenance windows, addressing the problem of routine platform upgrades landing at the same time for every customer, potentially during heavy workloads. Users can choose a two-hour UTC window, while Enterprise organizations can also specify the days of the week when maintenance is least disruptive. The setting covers ClickHouse-initiated Postgres minor-version upgrades, Managed Postgres feature updates, and patches to operating-system and system components, but not user-triggered changes or urgent storage scaling above 90% disk usage. Read replicas follow the schedule of their primary, and the feature is available without opt-in to Scale and Enterprise organizations; Basic users can see the setting and required plan.

Takeaways

1. 1

   Scheduled upgrades are available without opt-in to every Scale and Enterprise organization; Basic users can see the setting and the plan requirement.

2. 2

   The maintenance window applies to platform-initiated upgrades and patches, not user-triggered resizing, Postgres upgrades, or restarts.

3. 3

   Read replicas do not have independent schedules: they are upgraded alongside their primary service.