--- title: PostgreSQL extensions | Tiger Data Docs description: Browse and enable PostgreSQL extensions available in Tiger Cloud --- The following PostgreSQL extensions are installed with each Tiger Cloud service: - [Tiger Data extensions](#tiger-data-extensions) - [PostgreSQL built-in extensions](#postgresql-built-in-extensions) - [Third-party extensions](#third-party-extensions) ## Tiger Data extensions | Extension | Description | Enabled by default | | -------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------- | -------------------------------------------------------------- | | [pgai](/docs/reference/pgai/index.md) | Helper functions for AI workflows | For [AI-focused](/docs/get-started/index.md) services | | [pg\_textsearch](/docs/deploy/tiger-cloud/tiger-cloud-aws/tiger-cloud-extensions/pg-textsearch/index.md) | [BM25](https://en.wikipedia.org/wiki/Okapi_BM25)-based full-text search | Production-ready (v1.0.0) | | [pgvector](https://github.com/pgvector/pgvector) | Vector similarity search for PostgreSQL | For [AI-focused](/docs/get-started/index.md) services | | [pgvectorscale](https://github.com/timescale/pgvectorscale) | Advanced indexing for vector data | For [AI-focused](/docs/get-started/index.md) services | | [timescaledb\_toolkit](https://github.com/timescale/timescaledb-toolkit) | TimescaleDB Toolkit | For [Real-time analytics](/docs/get-started/index.md) services | | [timescaledb](https://github.com/timescale/timescaledb) | TimescaleDB | For all services | ## PostgreSQL built-in extensions | Extension | Description | Enabled by default | | -------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------- | ------------------ | | [autoinc](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-AUTOINC) | Functions for autoincrementing fields | - | | [amcheck](https://www.postgresql.org/docs/current/amcheck.html) | Functions for verifying relation integrity | - | | [bloom](https://www.postgresql.org/docs/current/bloom.html) | Bloom access method - signature file-based index | - | | [bool\_plperl](https://www.postgresql.org/docs/current/plperl-funcs.html) | Transform between bool and plperl | - | | [btree\_gin](https://www.postgresql.org/docs/current/btree-gin.html) | Support for indexing common datatypes in GIN | - | | [btree\_gist](https://www.postgresql.org/docs/current/btree-gist.html) | Support for indexing common datatypes in GiST | - | | [citext](https://www.postgresql.org/docs/current/citext.html) | Data type for case-insensitive character strings | - | | [cube](https://www.postgresql.org/docs/current/cube.html) | Data type for multidimensional cubes | - | | [dict\_int](https://www.postgresql.org/docs/current/dict-int.html) | Text search dictionary template for integers | - | | [dict\_xsyn](https://www.postgresql.org/docs/current/dict-xsyn.html) | Text search dictionary template for extended synonym processing | - | | [earthdistance](https://www.postgresql.org/docs/current/earthdistance.html) | Calculate great-circle distances on the surface of the Earth | - | | [fuzzystrmatch](https://www.postgresql.org/docs/current/fuzzystrmatch.html) | Determine similarities and distance between strings | - | | [hstore](https://www.postgresql.org/docs/current/hstore.html) | Data type for storing sets of (key, value) pairs | - | | [hstore\_plperl](https://www.postgresql.org/docs/current/hstore.html) | Transform between hstore and plperl | - | | [insert\_username](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-INSERT-USERNAME) | Functions for tracking who changed a table | - | | [intagg](https://www.postgresql.org/docs/current/intagg.html) | Integer aggregator and enumerator (obsolete) | - | | [intarray](https://www.postgresql.org/docs/current/intarray.html) | Functions, operators, and index support for 1-D arrays of integers | - | | [isn](https://www.postgresql.org/docs/current/isn.html) | Data types for international product numbering standards | - | | [jsonb\_plperl](https://www.postgresql.org/docs/current/datatype-json.html#DATATYPE-JSON-TRANSFORMS) | Transform between jsonb and plperl | - | | [lo](https://www.postgresql.org/docs/current/lo.html) | Large object maintenance | - | | [ltree](https://www.postgresql.org/docs/current/ltree.html) | Data type for hierarchical tree-like structures | - | | [moddatetime](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-MODDATETIME) | Functions for tracking last modification time | - | | [old\_snapshot](https://www.postgresql.org/docs/16/oldsnapshot.html) | Utilities in support of `old_snapshot_threshold` | - | | [pgcrypto](/docs/deploy/tiger-cloud/tiger-cloud-aws/tiger-cloud-extensions/pgcrypto/index.md) | Cryptographic functions | - | | [pgrowlocks](https://www.postgresql.org/docs/current/pgrowlocks.html) | Show row-level locking information | - | | [pgstattuple](https://www.postgresql.org/docs/current/pgstattuple.html) | Obtain tuple-level statistics | - | | [pg\_freespacemap](https://www.postgresql.org/docs/current/pgfreespacemap.html) | Examine the free space map (FSM) | - | | [pg\_prewarm](https://www.postgresql.org/docs/current/pgprewarm.html) | Prewarm relation data | - | | [pg\_stat\_statements](https://www.postgresql.org/docs/current/pgstatstatements.html) | Track execution statistics of all SQL statements executed | For all services | | [pg\_trgm](https://www.postgresql.org/docs/current/pgtrgm.html) | Text similarity measurement and index searching based on trigrams | - | | [pg\_visibility](https://www.postgresql.org/docs/current/pgvisibility.html) | Examine the visibility map (VM) and page-level visibility info | - | | [plperl](https://www.postgresql.org/docs/current/plperl.html) | PL/Perl procedural language | - | | [plpgsql](https://www.postgresql.org/docs/current/plpgsql.html) | SQL procedural language | For all services | | [postgres\_fdw](https://www.postgresql.org/docs/current/postgres-fdw.html) | Foreign data wrappers | For all services | | [refint](https://www.postgresql.org/docs/current/contrib-spi.html) | Functions for implementing referential integrity (obsolete) | - | | [seg](https://www.postgresql.org/docs/current/seg.html) | Data type for representing line segments or floating-point intervals | - | | [sslinfo](https://www.postgresql.org/docs/current/sslinfo.html) | Information about SSL certificates | - | | [tablefunc](https://www.postgresql.org/docs/current/tablefunc.html) | Functions that manipulate whole tables, including crosstab | - | | [tcn](https://www.postgresql.org/docs/current/tcn.html) | Trigger change notifications | - | | [tsm\_system\_rows](https://www.postgresql.org/docs/current/tsm-system-rows.html) | `TABLESAMPLE` method which accepts the number of rows as a limit | - | | [tsm\_system\_time](https://www.postgresql.org/docs/current/tsm-system-time.html) | `TABLESAMPLE` method which accepts the time in milliseconds as a limit | - | | [unaccent](https://www.postgresql.org/docs/current/unaccent.html) | Text search dictionary that removes accents | - | | [uuid-ossp](https://www.postgresql.org/docs/current/uuid-ossp.html) | Generate universally unique identifiers (UUIDs) | - | ## Third-party extensions | Extension | Description | Enabled by default | | ------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------- | ---------------------------------------------------- | | [h3](https://pgxn.org/dist/h3/) | H3 bindings for PostgreSQL | - | | [pgaudit](https://www.pgaudit.org/) | Detailed session and/or object audit logging | - | | [pgpcre](https://github.com/petere/pgpcre) | Perl-compatible RegEx | - | | [pg\_cron](https://github.com/citusdata/pg_cron) | SQL commands that you can schedule and run directly inside the database | [Contact us](mailto:support@tigerdata.com) to enable | | [pg\_repack](https://github.com/reorg/pg_repack) | Table reorganization in PostgreSQL with minimal locks | - | | [pgrouting](https://pgrouting.org/) | Geospatial routing functionality | - | | [postgis](/docs/deploy/tiger-cloud/tiger-cloud-aws/tiger-cloud-extensions/postgis/index.md) | PostGIS geometry and geography spatial types and functions | - | | [postgis\_raster](https://postgis.net/docs/RT_reference.html) | PostGIS raster types and functions | - | | [postgis\_sfcgal](https://postgis.net/docs/reference_sfcgal.html) | PostGIS SFCGAL functions | - | | [postgis\_tiger\_geocoder](https://postgis.net/docs/Extras.html#Tiger_Geocoder) | PostGIS Tiger Cloud geocoder and reverse geocoder | - | | [postgis\_topology](https://postgis.net/workshops/postgis-intro/topology.html) | PostGIS topology spatial types and functions | - | | [unit](https://github.com/df7cb/postgresql-unit) | SI units for PostgreSQL | - |