Extension name | Elastic storage mode (V6.0) | Elastic storage mode (V7.0) | Serverless mode | Description |
btree_gin | Supported | Supported | Supported | Allows you to create generalized inverted index (GIN) indexes for columns that are suitable for B-tree indexes. |
btree_gist | Supported | Supported | Supported | Uses a Generalized Search Tree (GiST) index structure to simulate B-tree behavior. |
dblink | Supported | Supported | Supported | Allows you to remotely access other PostgreSQL databases from a session of an AnalyticDB for PostgreSQL instance. |
citext | Supported | Supported | Supported | Provides a character string type that is case-insensitive called citext. |
fuzzystrmatch | Supported | Supported | Supported | Provides fuzzy match for character strings. |
ganos_geometry | Supported | Supported | Not supported | Provides a lightweight geometry extension of GanosBase. |
ganos_geometry_sfcgal | Supported | Supported | Not supported | Provides a lightweight geometry SFCGAL extension of GanosBase. |
ganos_geomgrid | Supported | Supported | Not supported | Provides a geometry grid extension of GanosBase. |
ganos_raster | Supported | Supported | Not supported | Provides a raster extension of GanosBase. |
ganos_spatialref | Supported | Supported | Not supported | Provides a spatial reference extension of GanosBase. |
ganos_trajectory | Supported | Supported | Not supported | Provides a trajectory extension of GanosBase. |
hll | Supported | Supported | Supported | Estimates the numbers of different elements in a HyperLogLog collection. |
hstore | Supported | Supported | Supported | Provides a data type called hstore to store sets of key-value pairs. |
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 a data type called ltree to store data in a hierarchical tree-like structure. |
odps_fdw | Supported | Supported | Supported | Allows you to access MaxCompute. |
orafce | Supported | Supported | Supported | Provides compatibility with specific Oracle functions. |
oss_fdw | Supported | Supported | Supported | Allows you to access Object Storage Service (OSS). |
pageinspect | Supported | Supported | Supported | Provides low-level checks on database pages. |
pg_hint_plan | Supported | Supported | Supported | Allows you to modify and optimize SQL statements by using hints to accelerate queries. |
pg_jieba | Supported | Supported | Supported | Allows you to perform Chinese full-text search. |
pg_prewarm | Not supported | Supported | Not supported | Allows you to prewarm relation data. |
pg_stat_statement | Supported | Supported | Supported | Allows you to track the execution statistics of all SQL statements that are executed. |
pg_trgm | Supported | Supported | Supported | Provides functions and operators that can be used to determine the similarity of text and index operators that support fast search for similar strings. |
pgcrypto | Supported | Supported | Supported | Supports encryption algorithm functions and allows you to store encrypted columns to further protect sensitive data. |
pldbgapi | Supported | Supported | Supported | Allows you to use the PL/pgSQL features to develop and debug functions in a simplified manner. |
postgres_fdw | Supported | Supported | Supported | Provides a PostgreSQL extension for cross-database queries. |
roaring bitmap | Supported | Supported | Supported | Provides a bitmap extension that uses the efficient roaring bitmap algorithm. |
sslinfo | Supported | Supported | Supported | Allows you to obtain the details of SSL database connections. |
tablefunc | Supported | Supported | Supported | Provides a table function extension. |
tdfunc | Supported | Supported | Supported | Allows you to use the subset features of Teradata and the features of functions and operators in Teradata. |
update_6_0_datatypecast_c | Supported | Supported | Supported | Allows you to implicitly convert data types in the C language from V4.3 to V6.0. |
uuid-ossp | Supported | Supported | Supported | Provides the UUID data type to store universally unique identifiers (UUIDs). UUIDs are more unique than sequences in distributed systems. |
zhparser | Supported | Supported | Not supported | Provides a Chinese word segmentation extension. |
Elastic Compute Service (ECS)
AgentBay
