Skip to content
Tagged articles

pg_upgrade

2 articles · Page 1 of 1
Cilantro Loves Linux
Cilantro Loves Linux
Sep 26, 2025 · Databases

PostgreSQL 18 Released: 5 Key Innovations for Performance, Upgrades & Developer Productivity

PostgreSQL 18 introduces major improvements including asynchronous I/O for up to 3x scan performance, pg_upgrade preserving statistics and --swap for minute-level upgrades, virtual generated columns, UUIDv7, temporal constraints, enhanced observability, OAuth 2.0 authentication, and parallel logical replication, reducing operational overhead and boosting developer productivity.

PostgreSQL 18UUIDv7asynchronous I/O
0 likes · 12 min read
PostgreSQL 18 Released: 5 Key Innovations for Performance, Upgrades & Developer Productivity
dbaplus Community
dbaplus Community
Dec 10, 2020 · Databases

How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade

In May 2020 GitLab partnered with OnGres to upgrade a 12‑node PostgreSQL 9.6 cluster to version 11, using a carefully planned pg_upgrade process, automated Ansible playbooks, Patroni HA, and a detailed rollback strategy to keep a 6 TB dataset consistent while serving 300 k transactions per second.

AnsibleDatabase MigrationGitLab
0 likes · 16 min read
How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade