Skip to content

PostgreSQL extensions

Browse and enable PostgreSQL extensions available for Tiger Cloud services

The following PostgreSQL extensions are available in every Tiger Cloud service.

Tiger Data extensions

ExtensionDescriptionEnabled by default
pgaiHelper functions for AI workflows
pg_textsearchBM25-based full-text search
pgvectorVector similarity search for PostgreSQL
pgvectorscaleAdvanced indexing for vector data
timescaledb_toolkitTimescaleDB Toolkit
timescaledbTimescaleDB

PostgreSQL built-in extensions

ExtensionDescriptionEnabled by default
autoincFunctions for autoincrementing fields
amcheckFunctions for verifying relation integrity
bloomBloom access method - signature file-based index
bool_plperlTransform between bool and plperl
btree_ginSupport for indexing common datatypes in GIN
btree_gistSupport for indexing common datatypes in GiST
citextData type for case-insensitive character strings
cubeData type for multidimensional cubes
dict_intText search dictionary template for integers
dict_xsynText search dictionary template for extended synonym processing
earthdistanceCalculate great-circle distances on the surface of the Earth
fuzzystrmatchDetermine similarities and distance between strings
hstoreData type for storing sets of (key, value) pairs
hstore_plperlTransform between hstore and plperl
insert_usernameFunctions for tracking who changed a table
intaggInteger aggregator and enumerator (obsolete)
intarrayFunctions, operators, and index support for 1-D arrays of integers
isnData types for international product numbering standards
jsonb_plperlTransform between jsonb and plperl
loLarge object maintenance
ltreeData type for hierarchical tree-like structures
moddatetimeFunctions for tracking last modification time
pgcryptoCryptographic functions
pgrowlocksShow row-level locking information
pgstattupleObtain tuple-level statistics
pg_buffercacheExamine the shared buffer cache
pg_freespacemapExamine the free space map (FSM)
pg_prewarmPrewarm relation data
pg_stat_statementsTrack execution statistics of all SQL statements executed
pg_trgmText similarity measurement and index searching based on trigrams
pg_visibilityExamine the visibility map (VM) and page-level visibility info
plperlPL/Perl procedural language
plpgsqlSQL procedural language
postgres_fdwForeign data wrappers
refintFunctions for implementing referential integrity (obsolete)
segData type for representing line segments or floating-point intervals
sslinfoInformation about SSL certificates
tablefuncFunctions that manipulate whole tables, including crosstab
tcnTrigger change notifications
tsm_system_rowsTABLESAMPLE method which accepts the number of rows as a limit
tsm_system_timeTABLESAMPLE method which accepts the time in milliseconds as a limit
unaccentText search dictionary that removes accents
uuid-osspGenerate universally unique identifiers (UUIDs)

Third-party extensions

ExtensionDescriptionEnabled by default
h3H3 bindings for PostgreSQL
pgauditDetailed session and/or object audit logging
pgpcrePerl-compatible RegEx
pg_cronSQL commands that you can schedule and run directly inside the database (contact support to enable)
pg_repackTable reorganization in PostgreSQL with minimal locks
pgroutingGeospatial routing functionality
postgisPostGIS geometry and geography spatial types and functions
postgis_rasterPostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
postgis_tiger_geocoderPostGIS Tiger Cloud geocoder and reverse geocoder
postgis_topologyPostGIS topology spatial types and functions
unitSI units for PostgreSQL