AnalyticDB for PostgreSQL supports open source and self-developed PostgreSQL extensions. Use them to add capabilities such as hint-based SQL optimization, job scheduling, cross-database queries, geospatial analysis, full-text search, and bitmap operations directly within your instance.
Usage notes
The extensions listed here are available on the recommended or latest minor version of AnalyticDB for PostgreSQL. If an extension does not appear on the Extensions page of your instance, update the instance to the recommended or latest minor version. For details, see Update the minor version of an instance.
Extensions
The following table lists all supported extensions and their availability across instance modes. Extensions marked as Not supported in a given mode are unavailable in that mode regardless of version.
| Extension | Elastic storage mode (V6.0) | Elastic storage mode (V7.0) | Serverless mode | Description |
|---|---|---|---|---|
| btree_gin | Supported | Supported | Supported | Creates Generalized Inverted Index (GIN) indexes for columns that are suitable for B-tree indexes. Useful when you want GIN-style indexing on data types that normally use B-tree indexes. |
| btree_gist | Supported | Supported | Supported | Uses a Generalized Search Tree (GiST) index structure to simulate B-tree behavior. |
| citext | Supported | Supported | Supported | Provides a case-insensitive character string type, eliminating the need to apply lower() on every comparison. |
| dblink | Supported | Supported | Supported | Accesses other PostgreSQL databases remotely from an AnalyticDB for PostgreSQL session. |
| fuzzystrmatch | Supported | Supported | Supported | Provides fuzzy string matching functions for approximate string comparisons. |
| ganos_geometry | Supported | Supported | Not supported | Provides the GanosBase lightweight geometry extension for storing and querying vector spatial data. |
| ganos_geometry_sfcgal | Supported | Supported | Not supported | Provides the GanosBase lightweight geometry extension with SFCGAL support for advanced 3D geometry operations. |
| ganos_geomgrid | Supported | Supported | Not supported | Provides the GanosBase geometry grid extension for spatial grid indexing and discrete global grid systems. |
| ganos_raster | Supported | Supported | Not supported | Provides the GanosBase raster extension for storing, processing, and analyzing raster data such as satellite imagery. |
| ganos_spatialref | Supported | Supported | Not supported | Provides the GanosBase spatial reference extension for coordinate system definition and transformation. |
| ganos_trajectory | Supported | Supported | Not supported | Provides the GanosBase trajectory extension for storing and querying moving object data such as GPS tracks. |
| hll | Supported | Supported | Supported | Estimates the cardinality of large datasets using the HyperLogLog algorithm, with low memory overhead compared to exact counts. |
| hstore | Supported | Supported | Supported | Provides the hstore data type for storing key-value pairs within a single column. |
| isn | Not supported | Supported | Not supported | Provides a data type called isn to support international product numbering standards. |
| ltree | Not supported | Supported | Not supported | Provides the ltree data type for storing and querying hierarchical tree-structured data. |
| odps_fdw | Supported | Supported | Supported | Queries MaxCompute (ODPS) tables as foreign tables directly from AnalyticDB for PostgreSQL, without data movement. |
| orafce | Supported | Supported | Supported | Provides functions and operators compatible with specific Oracle built-ins, reducing the effort needed to migrate Oracle workloads. |
| oss_fdw | Supported | Supported | Supported | Reads from and writes to Object Storage Service (OSS) as foreign tables, enabling direct queries over data in OSS. |
| pageinspect | Supported | Supported | Supported | Provides functions for low-level inspection of database page contents, useful for diagnosing storage and indexing issues. |
| pg_hint_plan | Supported | Supported | Supported | Overrides the query planner's decisions using SQL hints, enabling manual optimization of specific queries. |
| pg_jieba | Supported | Supported | Supported | Provides Chinese word segmentation for full-text search using the Jieba tokenizer. |
| pg_prewarm | Not supported | Supported | Not supported | Loads relation data into the buffer cache to warm up query performance after a database restart. |
| pg_stat_statement | Supported | Supported | Supported | Tracks execution statistics for all SQL statements, including execution count, total time, and row counts, for query performance analysis. |
| pg_trgm | Supported | Supported | Supported | Provides trigram-based similarity functions and index operators for fast fuzzy string search. |
| pgcrypto | Supported | Supported | Supported | Provides cryptographic functions for encrypting and decrypting column data to further protect sensitive data. |
| pldbgapi | Supported | Supported | Supported | Enables interactive debugging of PL/pgSQL functions and stored procedures. |
| postgres_fdw | Supported | Supported | Supported | Queries tables in external PostgreSQL databases as foreign tables, supporting cross-database joins and reads. |
| roaring bitmap | Supported | Supported | Supported | Provides compressed bitmap operations using the roaring bitmap algorithm for efficient set computations on large integer datasets. |
| sslinfo | Supported | Supported | Supported | Returns SSL certificate and connection details for the current session, useful for auditing encrypted connections. |
| tablefunc | Supported | Supported | Supported | Provides a table function extension. |
| tdfunc | Supported | Supported | Supported | Provides a subset of Teradata-compatible functions and operators to simplify migration from Teradata. |
| update_6_0_datatypecast_c | Supported | Supported | Supported | Enables implicit data type casting in C to support migration from V4.3 to V6.0. |
| uuid-ossp | Supported | Supported | Supported | Generates universally unique identifiers (UUIDs) using standard algorithms. UUIDs avoid the sequence contention common in distributed writes. |
| zhparser | Supported | Supported | Not supported | Provides Chinese word segmentation for full-text search using the SCWS engine, an alternative to pg_jieba. |
Note
The six GanosBase extensions (ganos_geometry, ganos_geometry_sfcgal, ganos_geomgrid, ganos_raster, ganos_spatialref, ganos_trajectory) and zhparser are not available in Serverless mode. The extensions isn, ltree, and pg_prewarm are not available in Elastic storage mode V6.0.