ClickHouse Managed Postgres: Schedule Your Upgrades

Predictable Postgres Maintenance

The introduction of scheduled upgrades in ClickHouse Managed Postgres is a welcome and practical advancement for database administrators and development teams. Previously, platform maintenance was a 'one-size-fits-all' affair, potentially disrupting critical workloads. By allowing users to define a specific maintenance window, ClickHouse empowers them to align database upkeep with periods of low activity, thereby minimizing operational risk and improving service availability. This feature directly addresses a core concern in managed database services: the trade-off between automated patching for security and performance, and the need for predictable control over system changes. The tiered approach, offering more granular control (specific days of the week) on the Enterprise plan, is also a smart move to cater to different organizational needs and budgets. The clarity provided on what the window does and does not cover (e.g., user-initiated actions, urgent capacity scaling) is crucial for setting accurate expectations and preventing misunderstandings.

However, a key limitation to consider is the inherent dependency on ClickHouse's release schedule. While users can schedule when these upgrades land, they cannot prevent them entirely or dictate the specific version of Postgres being rolled out during the maintenance window. The article implies that the window is for 'platform maintenance' and 'whenever the next release is ready,' suggesting that users are still consuming ClickHouse's curated updates rather than having full control over version selection. This might be a concern for organizations with strict version control requirements or those needing to test specific minor versions before deployment. Furthermore, the note that read replicas do not have their own schedules and are upgraded with the primary is a standard practice but worth reiterating for clarity, as it implies that primary maintenance will inherently affect replica availability during that window. Despite these points, the overall benefit of increased predictability and control for routine maintenance makes this a valuable addition.

Key Points

• ClickHouse Managed Postgres now offers scheduled upgrades, allowing users to define a maintenance window for platform updates.
• This feature aims to minimize disruption by aligning database maintenance with periods of low workload.
• Users can select a two-hour window in UTC.
• Enterprise plan users have the additional option to specify particular days of the week for maintenance.
• The scheduled upgrades cover platform maintenance initiated by ClickHouse, such as minor version upgrades, security patches, and updates to Managed Postgres features.
• User-initiated actions (resizing, version upgrades, restarts) and urgent capacity scaling (e.g., disk usage exceeding 90%) are excluded from the scheduled maintenance window.
• Read replicas inherit the schedule of their primary instance and do not have independent scheduling.
• The feature is available to Scale and Enterprise organizations without opt-in.

---

📖 Source: Introducing Scheduled Upgrades in ClickHouse Managed Postgres