Common extensions

See also:
* Joel Jacobson's 2022 list of 1000+ extensions https://www.postgresql.org/message-id/flat/c556d011-c7fd-49bd-8ce4-8993dd074868%40www.fastmail.com
* Database of extensions put together by Deepak Mahto https://pgextensions.org/
* Database of extensions maintained by Evan H. Stanton https://tembo-io.notion.site/postgresql_extension_support-99a3595cffe94437bd233e04e089859a
* Pigsty list of 255 supported extensions (as of May 2024, this isn't on Evan's list) https://www.postgresql.org/about/news/pigsty-v27-released-free-rds-pg-with-255-extensions-available-2863/
.
----
Starting a table of some common extensions, based on where they are distributed/supported
Sources:
* Debian repo: Packages distributed https://qa.debian.org/developer.php?login=pkg-postgresql-public@lists.alioth.debian.org
** See also Apt/Packages
* PGDG apt: git repo https://git.postgresql.org/gitweb/?p=pgapt.git;a=blob;f=jenkins/pgapt-jobs.yaml
** (build script for PGDG apt packages; i think it's the best place to see what all is included in this repo)
* PGDG yum: git repo https://git.postgresql.org/gitweb/?p=pgrpms.git;a=tree;f=rpm/redhat/16;hb=HEAD
** See also RPM chart for repo https://yum.postgresql.org/rpmchart/
** See also list of extensions at PostgreSQL_16_Extension_Bugs
* PGXN source: https://pgxn.org/
Note: the same extension can have differently named packages in different distribution channels
.
TODO: i've added all packages from the debian repo, still need to check for packages in PGDG apt repo and the PGDG yum repo that aren't here
TODO: add & populate more columns, for example: BSDs? k8s operators? does EDB "stackbuilder" tool install some of these on windows/mac? widely used cloud providers?
TODO: remove entries that aren't distributed in at least two places??
Extension 	Debian repo	PGDG yum	PGXN source	Short Description
postgis 	yes 	yes 	no 	Geographic objects support
pgrouting 	yes 	yes 	no 	extends PostGIS to provide geospatial routing functionality
pgsql-ogr-fdw 	yes 	yes 	yes 	OGR is the vector half of the GDAL spatial data access library
hypopg 	yes 	yes 	yes 	PostgreSQL extension adding support for hypothetical indexes
ip4r 	yes 	yes 	no 	IPv4 and IPv6 types
orafce 	yes 	yes 	yes 	Oracle support functions
pg-rage-terminator 	yes 	no 	no 	PostgreSQL background worker that kill random sessions
pgextwlist 	yes 	no 	no 	PostgreSQL Extension Whitelisting
pgfincore 	yes 	yes 	no 	set of PostgreSQL functions to manage blocks in memory
pgl-ddl-deploy 	yes 	yes 	no 	Transparent DDL replication
pgmemcache 	yes 	yes 	no 	PostgreSQL user-defined functions that provide an interface to memcached
pgsql-asn1oid 	yes 	no 	no 	ASN.1 OID data type
pgtap 	yes 	yes 	yes 	Unit testing framework
plr 	yes 	yes 	no 	PostgreSQL user-defined functions that provide an interface to memcached
postgresql-debversion	yes 	no 	no 	Debian version number type
postgresql-hll 	yes 	yes 	yes 	HyperLogLog extension
postgresql-pgmp 	yes 	yes 	yes 	arbitrary precision integers and rationals for PostgreSQL
postgresql-pllua 	yes 	yes 	no 	Lua procedural language
postgresql-plproxy 	yes 	no 	yes 	database partitioning/sharding system
postgresql-plsh 	yes 	yes 	no 	PL/sh procedural language
postgresql-prioritize	yes 	yes 	yes 	Get and set the nice priorities of PostgreSQL backends
postgresql-unit 	yes 	no 	no 	SI Units (intl system of units)
prefix 	yes 	yes 	no 	Prefix Range module
preprepare 	yes 	no 	no 	pre prepare your PostgreSQL statements server side
toastinfo 	yes 	no 	no 	Show storage structure of varlena datatypes
wal2json 	yes 	yes 	no 	PostgreSQL logical decoding JSON output plugin