Two years later, I have been building an open-source infra for PG extensions. It is called **pgext.cloud**. Today, it ships across sixteen Linux targets and five active PostgreSQL major versions. Together with PGDG and contrib, the deliverable set is about 511 extensions. The repository serves roughly one million downloads per month. Several PostgreSQL vendors now deliver their extensions through it. But this talk is not mainly about the repository. The main point is what we learned while maintaining this matrix. That is what I want to share today.

Part I. Introduction

Two Years Later

PIGSTY
Extension Coverage Baseline Extension Stat table from the PostgreSQL Extension Catalog
Each column is normalized to its own ALL row, so the bars show coverage inside that platform scope.

Extension scope

All

511extensions
511
155
339
71
0
491
492
484
478
461

Extension scope

EL

506extensions
506
150
339
71
5
482
486
479
472
455

Extension scope

Debian

496extensions
496
107
318
71
15
476
478
469
462
445