PostgreSQL Extension Analysis
This website contains the results ran by ExtAnalyzer! on PostgreSQL's extensibility ecosystem, our extension analysis toolkit. The toolkit automatically downloads and installs 441 extensions from PostgreSQL's contrib directory, cloud vendors (AWS RDS, Google Cloud SQL, Azure PostgreSQL), and PostgreSQL Extension Network (PGXN).
We run four different analyses on each extension:
- Information Analysis: Collects extensibility types and system components used in each extension.
- Duplicate Code Analysis: Uses CPD to extract the number of lines each extension copies from PostgreSQL's source code.
- Versioning Analysis: Extracts the number of lines of code each extension has encapsulated in the
PG_VERSION_NUMmacro. - Compatibility Analysis: Tests pairs of extensions for compatibility by running their unit tests with both installed. For pairs of indexes and UDTs, we also try combining them by inserting instances of these UDTs into the indexes.
We discuss the results collected in our toolkit more in depth in our paper (below).
Papers
People
Acknowledgements
This paper would not have been possible without the help of the Carnegie Mellon Database Group. The authors would also like to thank Erik Nordstrom for helping us support Timescale in the toolkit, and the people at the PostgreSQL Development Conference 2024 for their amazing feedback and enthusiasm for the research!