We are upgrading the operating system on our Postgres database clusters

GitLab.com's transition to Ubuntu 20.04 for its Postgres database clusters involves a complex process aimed at enhancing performance and reliability, necessitating a planned service downtime. The upgrade from Ubuntu 16.04 is critical due to changes in glibc affecting Postgres indexes, potentially corrupting them, which requires a maintenance window on September 3, 2022, from 11:00 UTC to 14:00 UTC. During this period, GitLab.com will undergo a complete service disruption to ensure data integrity and proper functioning post-upgrade. The strategy involves using Postgres streaming replication to transfer data to new Ubuntu 20.04 clusters and reindexing potentially corrupt indexes, with particular focus on B-Tree, GiST, Hash, and GIN indexes, to minimize downtime and customer impact. Enhancements in performance include a significant improvement in the speed of the amcheck script to detect corrupt B-Tree indexes and advancements in reindexing speed, achieved by parallelizing processes and optimizing Postgres parameters. The upgrade process has been carefully planned, with measures in place to maintain business continuity and address potential index corruption efficiently.

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.