Extensions on Aiven for PostgreSQL®
PostgreSQL® extensions allow you to extend the functionality by adding more capabilities to your Aiven for PostgreSQL.
important
Some extensions:
- Have dependencies and need to be created in a predetermined order.
- Require resetting the client connection before they are fully available.
To list the extensions and their details, such as extension version numbers,
run select * from pg_available_extensions
in your Aiven for PostgreSQL server.
note
Not all extensions listed in pg_available_extensions
can be installed. See
Superuser-only extensions
for more information.
Data types
- citext. Data type for case-insensitive character strings.
- cube. Data type for multidimensional cubes.
- hll. Type for storing
hyperloglog
data.PG11 and newer
- hstore. Data type for storing sets of (key, value) pairs.
- isn. Data types for international product numbering standards.
- ltree. Data type for hierarchical tree-like structures.
- pgvector. Type for vector
similarity search.
PG13 and newer
- seg. Data type for representing line segments or floating-point intervals.
- timescaledb. Enables scalable inserts and complex queries for time-series data.
- unit. SI units extension.
- uuid-ossp. Generate universally unique identifiers (UUIDs).
Search and text handling
- bloom. Bloom access method - signature file based index.
- btree_gin. Support for indexing common data types in GIN.
- btree_gist. Support for indexing common data types in GiST.
- dict_int. Text search dictionary template for integers.
- fuzzystrmatch. Determine similarities and distance between strings.
- pg_similarity. Support
similarity queries.
PG13 and newer
- pg_trgm. Text similarity measurement and index searching based on trigrams.
- pgcrypto. Cryptographic functions.
- rum. RUM index access method.
- unaccent. Text search dictionary that removes accents.
Auditing
- tcn. Triggered change notifications.
Geographical features
- address_standardizer. Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
- address_standardizer_data_us.
Address standardizer
US dataset example. - earthdistance. Calculate great-circle distances on the surface of the Earth.
- h3. PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system.
- h3_postgis. H3 PostGIS integration.
- pgrouting. Extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.
- postgis. PostGIS geometry and geography spatial types and functions.
- postgis_legacy. Legacy functions for PostGIS.
- postgis_raster. PostGIS raster types and functions.
- postgis_sfcgal. PostGIS SFCGAL functions.
- postgis_tiger_geocoder. PostGIS tiger geocoder and reverse geocoder.
- postgis_topology. PostGIS topology spatial types and functions.
Procedural language
Connectivity
- dblink. Connect to other PostgreSQL databases from within a database.
- postgres_fdw. Foreign-data wrapper for remote PostgreSQL servers.
Utilities
- aiven_extras. This extension is meant for use in environments where you want non-superusers to be able to use certain database features.
- bool_plperl.
Transform between
bool
andplperl
.PG13 and newer
- intagg. Integer aggregator and enumerator (obsolete).
- intarray. Functions, operators, and index support for 1-D arrays of integers.
- jsonb_plperl.
Transform between
jsonb
andplperl
. - lo. Large Object maintenance.
- pageinspect. Inspect the contents of database pages at a low level.
- pg_buffercache. Examine the shared buffer cache.
- pg_cron. Job scheduler for PostgreSQL.
- pg_partman. Extension to manage partitioned tables by time or ID.
- pg_prewarm.
Prewarm relation data.
PG11 and newer
- pg_prometheus.
Prometheus metrics for PostgreSQL.
PG12 and earlier
- pg_repack. Reorganize tables in PostgreSQL databases with minimal locks.
- pg_stat_statements. Track planning and execution statistics of all SQL statements executed.
- pgrowlocks. Show row-level locking information.
- pgstattuple. Show tuple-level statistics.
- sslinfo. Information about SSL certificates.
- tablefunc.
Functions that manipulate whole tables, including
crosstab
. - timetravel.
Functions for implementing time travel.
PG11 and earlier
- tsm_system_rows. TABLESAMPLE method which accepts number of rows as a limit.
- tsm_system_time. TABLESAMPLE method which accepts time in milliseconds as a limit.
Superuser-only extensions
The following extensions can only be installed by superusers, and are not generally available.
- amcheck. Functions for verifying relation integrity.
- autoinc.
Functions for auto-incrementing fields.
PG13 and newer
- dict_xsyn. Text search dictionary template for extended synonym processing.
- file_fdw. Foreign-data wrapper for flat file access.
- hstore_plperl.
Transform between
hstore
andplperl
. - insert_username. Functions for tracking who changed a table.
- moddatetime. Functions for tracking last modification time.
- old_snapshot.
Utilities in support of old_snapshot_threshold.
PG14 only
- pageinspect. Inspect the contents of database pages at a low level.
- pg_freespacemap. Examine the free space map (FSM).
- pg_surgery.
Extension to perform surgery on a damaged relation.
PG14 only
- pg_visibility. Examine the visibility map (VM) and page-level visibility info.
- refint. Functions for implementing referential integrity (obsolete).