Group extensions by order of magnitude, and we get a simple tier model. Tier zero — the magnificent four. PostGIS, TimescaleDB, pgvector, Citus. More than ten thousand stars each. Tier one — 44 extensions, between one thousand and ten thousand. Tier two — about 152 extensions, above one hundred. Tier three — about 373 extensions, above ten. And a long tail of around 748 extensions below ten stars. This is not a quality ranking. Some popular projects are no longer active, like pgml or zombodb. Some low-star extensions are quite useful. But the tiers tell us something. The visible ecosystem is much smaller than the discovered one. Adding tiers zero through three gives about 570 extensions with more than ten stars — close to what is actually deliverable.

Part II : The Ecosystem Landscape

Star Tiering

PIGSTY
T0
10K+Flagship
4packages
T1
1K+Popular
44packages
T2
100+Recognized
152packages
T3
10+Visible
373packages
T4
<10Long Tail
748packages
Not quality scores.T0-T3 add up to roughly 570 packages with more than ten stars.
Extension list
T0
postgistimescaledbpgvectorcitus
T1
pg_searchpgmlpgaipgmqzombodbageruvector-postgresorioledbpg_cronpg_textsearchrdkitdocumentdbpg_graphqlpg_duckdbhydrapgvectorscalepg_partmanpipelinedbpg_repackvectorsplv8pg_mooncakecstore_fdwindex_advisorrepmgrvchordhypopgpgauditomnigrespg_httppg_lakewal2jsonpg_ivmpg_strompgroutingplrustpgautofailoverpglogicalhllpg_jsonschemapgtappgactivepg_shardivorysql
T2
pg_hint_planlantern_extraszhparserwrapperspg_vectorizerumpglite_fusionpowaplpgsql_checkuuid47pgroongaspockjsquerypg_parquetpg_squeezemobilitydbpgsodiummysql_fdwpg_pathmanembeddingpg_stat_monitorzsonoracle_fdwpg_analyticsorafceredis_fdwpostgres-json-schemapgx_ulidaqopg_bulkloadplprqltimescaledb_toolkitpgjwtopenhalo...
T3
pgl_ddl_deploypostgres-uuidv7-sqlpg_sqidspgtttdigestpg_bestmatchpg_libphonenumberpg_statvizpg_plan_filterpgmonitordatasketchespg_ducklakesnowflakepldebuggeremajjsoncdcq3cpg_aclpg_gzippg_catcheckpg_column_tetrispgh3supautilscount_distinctcredcheckgitgresmimeopg_enquojdbc_fdwset_useruids-postgresbg_montwitter_fdwodbc_fdw...
T4
colnamesconfig_logcryptintdatalinkmd5hashmeta_triggerspg_auditorpg_countrypg_grants_managerpg_hash64pg_json_querypg_octopuspgautquery_recorderredis_linkreplisomeshacrypttrimmed_aggregates...