We want to write a paper on the vast extensions ecosystem for Postgres at some point. It's on my TODO list for 2023.

Having so many plug-ins/add-ons available is unique to Postgres and due to Stonebraker's original vision of including extensibility as a first-class design principle in the DBMS.