~/talk

How we execute PG major upgrades at GitLab, with zero downtime.

on YouTube 49m
Talkat PostgreSQL Conference Europe 2023 · 2023-12-12..12-15· [databases]

speaker

name:Alexander Sosna
links:none on file

resources

video:https://youtu.be/o08kJggkovg
slides:none on file

summary

Zero downtime means no customer-facing outages while major Postgres upgrades still complete; GitLab moves a physical snapshot to a target cluster, runs pg_upgrade there, then uses logical replication (replication slot + publication) to stream recent writes while the old cluster keeps serving traffic. Sequences get a pragmatic fix—precomputed per-sequence offsets (example: bump sequences by 1,000,000)—and the whole process is automated (Ansible) with staged read-only traffic and careful file sync checks.

AI-written summary · about

chapters (6)

  1. 0:00Introduction and Strategy
  2. 24:50Preparing the Environment
  3. 26:04Executing the Upgrade
  4. 31:48Switchover and Verification
  5. 38:33Post-Upgrade Analysis
  6. 41:45Future Improvements & Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.