Skip to main content

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​

  • plperl. PL/Perl procedural language.
  • plpgsql. PL/pgSQL 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 and plperl. 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 and plperl.
  • 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 and plperl.
  • 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).