postgresql.org: The hidden parts
summary
Volunteer-run PGInfra of seven people runs git.postgresql.org with a hidden master, the canonical downloads and apt/yum repos, 67 VMs across multiple providers, and a buildfarm with a 15 TB archive. Traffic hits include 66 million hits/day and 10 terabytes/day for downloads, website ~80–100 req/s with three frontends and one backend, and 32 PostgreSQL instances. Pain points are a flaky Cisco ASA firewall, AI bots flooding the wiki and gitweb, and hard-to-maintain MediaWiki; needs include another data center with dedicated, unmetered hardware and native IPv4/IPv6.
AI-written summary · about
chapters (8)
- 0:00Introduction to PG Infra
- 3:39Services managed by PG Infra
- 10:22Infrastructure and redundancy
- 15:18Public-facing services details
- 19:51Pain points and challenges
- 23:03How to help PG Infra
- 24:27Can others run these services?
- 26:34Closing and Q&A
related talks
13mBuilding reliable infrastructure with Postgres
55mManaging PostgreSQL with Puppet
46mHow we made PG Fitter, Happier, More Productive
44mBenchmarking your commits: The Postgres Performance Farm
19mPGDay Lowlands 2025 Lightning Talks
35mHow to Host a (Very) Popular Website for 30 Altairian...
40mHacking the Pachyderm: Scaling Servers and People
36mPostgreSQL: Ups, DevOps...