Skip to content
Products
Platform
Developer Tools
Portal

Supported extensions in PostgreSQL Flex

Last updated on

PostgreSQL Flex ships with a variety of extensions. This page lists them by category. Read Enable and manage extensions in PostgreSQL Flex, to learn how-to use them.

Performance, monitoring and optimization

Section titled “Performance, monitoring and optimization”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1btree_gistProvides GiST index operator classes that implement B-tree equivalent behavior
Yes
Yes
Yes
Yes
Yes
2btree_ginProvides GIN index operator classes that implement B-tree equivalent behavior
Yes
Yes
Yes
Yes
Yes
3hypopgCreate “hypothetical” indexes to see if the query planner would use them without actually building them.
Yes
Yes
Yes
Yes
Yes

Text search and fuzzy matching

Section titled “Text search and fuzzy matching”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1pg_trgmDetermines alphanumeric similarity using trigrams (great for fuzzy search and index-driven LIKE queries).
Yes
Yes
Yes
Yes
Yes
2fuzzystrmatchThe fuzzystrmatch module provides functions to determine similarities and distance between strings.
Yes
Yes
Yes
Yes
Yes
3unaccentIs a text search dictionary that removes accents (diacritic signs) from lexemes.
Yes
Yes
Yes
Yes
Yes
4citextProvides a case-insensitive character string type
Yes
Yes
Yes
Yes
Yes

Specialized data types and structures

Section titled “Specialized data types and structures”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1vector (pgvector)Adds vector data types and distance metrics, primarily used for AI/Machine Learning embeddings and semantic search
Yes
Yes
Yes
Yes
Yes
2uuid-osspGenerates universally unique identifiers (UUIDs) using standard algorithms.
Yes
Yes
Yes
Yes
Yes
3hstoreImplements a data type for storing sets of key-value pairs
Yes
Yes
Yes
Yes
Yes
4ltreeImplements a data type for representing labels of data stored in a hierarchical, tree-like structure.
Yes
Yes
Yes
Yes
Yes
5intarrayProvides a number of useful functions and operators for manipulating null-free arrays of integers.
Yes
Yes
Yes
Yes
Yes
6cubeImplements a data type for multidimensional cubes (often used as a foundation for earthdistance).
Yes
Yes
Yes
Yes
Yes
7hllImplements HyperLogLog data structure for distinct value estimation.
Yes
Yes
Yes
Yes
Yes
8timescaledbOptimizes PostgreSQL for time-series and analytical workloads using hypertables and columnar compression.
Yes
Yes
Yes
Yes
Yes

Geospatial analysis

Section titled “Geospatial analysis”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1postgisextends the capabilities of the PostgreSQL relational database by adding support for storing, indexing, and querying geospatial data.
Yes
Yes
Yes
Yes
Yes
2earthdistanceA lightweight alternative to PostGIS for calculating great-circle distances on the surface of the Earth (requires cube).
Yes
Yes
Yes
Yes
Yes
3postgis_rasterPostGIS type for storing and analyzing raster data.
Yes
Yes
Yes
Yes
Yes
4postgis_sfcgalProvides standard compliant geometry types and operations.
Yes
Yes
Yes
Yes
Yes
5postgis_topologyThe PostGIS Topology types and functions are used to manage topological objects such as faces, edges, and nodes.
Yes
Yes
Yes
Yes
Yes
6address_standardizerThe PostGIS extras types and functions
Yes
Yes
Yes
Yes
Yes
7address_standardizer_data_usThe PostGIS extras types and functions
Yes
Yes
Yes
Yes
Yes

Database administration and maintenance

Section titled “Database administration and maintenance”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1pg_partmanAutomates the creation and management of time-series or ID-based table partitions.
Yes
Yes
Yes
Yes
Yes
2pg_repackRemoves bloat from tables and indexes without holding heavy locks (unlike a standard VACUUM FULL). (Note: -k must be specified to skip superuser checks)
Yes
Yes
Yes
Yes
Yes
3postgres_fdwA Foreign Data Wrapper used to read and write data in other, external PostgreSQL servers.
Yes
Yes
Yes
Yes
Yes
4amcheckVerifies the logical consistency of the structure of your B-tree indexes to catch corruption early.
Yes
Yes
Yes
Yes
Yes
5pgstattupleProvides functions to inspect page-level statistics and accurately detect table/index bloat.
Yes
Yes
Yes
Yes
Yes
6loProvides support for managing Large Objects (also called LOs or BLOBs).
Yes
Yes
Yes
Yes
Yes

Security and auditing

Section titled “Security and auditing”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1pgcryptoProvides cryptographic functions (hashing, symmetric/asymmetric encryption) directly inside SQL.
Yes
Yes
Yes
Yes
Yes

Advanced querying and programmability

Section titled “Advanced querying and programmability”
Extension NameDescriptionPG 14PG 15PG 16PG 17PG 18
1tablefuncProvides functions that produce entire tables, crosstab for creating pivot tables.
Yes
Yes
Yes
Yes
Yes
2extra_window_functionsSupplies additional window functions to expand analytical SQL capabilities.
Yes
Yes
Yes
Yes
Yes
3first_last_aggProvides first() and last() aggregate functions (handy for getting the earliest/latest row in a grouped set).
Yes
Yes
Yes
Yes
Yes
4tcnProvides a trigger function that notifies listeners of changes to any table on which it is attached
Yes
Yes
Yes
Yes
Yes