Supported Plugins List
This document lists the plugins and their versions supported by various versions of UPgSQL.
Note:
- This page only lists commonly used plugins. For more information on plugin support, you can query within the database using the SELECT * FROM pg_available_extensions; command.
- Some plugins need to be added to the shared_preload_libraries parameter before use, otherwise the plugin cannot be created.
| Plugin Name | Version 13.4 | Version 12.8 | Version 10.4 | Version 9.6 | Description |
|---|---|---|---|---|---|
| postgis | 3.0.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS spatial geographic information related extension |
| pg_cron | None | 1.4-1 | 1.4-1 | 1.4-1 | Set up scheduled tasks |
| pg_partman | None | 4.6.0 | 4.6.0 | 4.6.0 | Extension to automatically create and maintain table partitioning |
| pg_pathman | None | 1.5 | 1.5 | 1.5 | High-performance partition table plugin |
| mysql_fdw | None | 1.1 | 1.1 | None | Read and write data in MySQL database |
| pg_bigm | None | 1.2 | 1.2 | 1.2 | Creates a binary grammar (2-gram) GIN index to speed up the full-text search process |
| plproxy | None | 2.10.0 | 2.10.0 | 2.10.0 | Contains CLUSTER and CONNECT modes, can help you access the database in different ways |
| pg_hint_plan | None | 1.3.7 | 1.3.6 | 1.2.7 | Through special comment prompts, allowing PostgreSQL to change its established execution plan |
| pgaudit | None | 1.4.3 | 1.2.4 | 1.1.4 | Provides detailed session and object audit logging |
| pg_repack | None | 1.4.6 | 1.4.6 | 1.4.6 | Online cleanup table space functionality |
| hypopg | None | 1.3.2 | 1.3.2 | 1.3.2 | Creating virtual indexes |
| sequential_uuids | None | 1.0.2 | 1.0.2 | 1.0.2 | UUID generator |
| pg_squeeze | None | 1.4 | 1.4 | 1.4 | Removes unused space from table and optionally sorts tuples according to a specific index |
| roaringbitmap | None | 0.2.66 | 0.2.66 | 0.2.66 | Using bitmap functionality, improve query performance. |
| aggs_for_arrays | None | 1.3.2 | 1.3.2 | 1.3.2 | Provides extended functions for calculating statistics about numeric arrays. |
| dblink | 1.2 | 1.2 | 1.2 | 1.2 | Cross-database operation table |
| btree_gin | 1.3 | 1.3 | 1.2 | 1.0 | Provides an example of a GIN operator class that implements B-tree equivalent behavior for various data types and all enum types |
| btree_gist | 1.5 | 1.5 | 1.5 | 1.2 | Provides an example of a GiST operator class that implements B-tree equivalent behavior for various data types and all enum types |
| chkpass | None | None | 1.0 | 1.0 | Implements a data type used to store encrypted passwords |
| citext | 1.6 | 1.6 | 1.4 | 1.3 | Provides a case-insensitive string type |
| cube | 1.4 | 1.4 | 1.2 | 1.2 | Provides a data type for representing multidimensional cubes |
| dict_int | 1.0 | 1.0 | 1.0 | 1.0 | Example of an additional full-text search dictionary template |
| earthdistance | 1.1 | 1.1 | 1.1 | 1.1 | Provides two different methods to calculate the great-circle distance on the earth’s surface |
| fuzzystrmatch | 1.1 | 1.1 | 1.1 | 1.1 | Decide the similarity and distance between strings |
| hstore | 1.6 | 1.6 | 1.4 | 1.4 | Stores key-value pairs in a single PostgreSQL value |
| intagg | 1.1 | 1.1 | 1.1 | 1.1 | Provides an integer aggregator and an enumerator |
| intarray | 1.3 | 1.2 | 1.2 | 1.2 | Provides some useful functions and operators to manipulate non-empty integer arrays |
| isn | 1.2 | 1.2 | 1.1 | 1.1 | Validates input against a hardcoded prefix list and is also used to concatenate numbers in output |
| ltree | 1.2 | 1.1 | 1.1 | 1.1 | Used to represent labels stored in a hierarchical tree-like data structure |
| pg_buffercache | 1.3 | 1.3 | 1.3 | 1.2 | Provides a way to check shared buffer in real time |
| pg_freespacemap | 1.2 | 1.2 | 1.2 | 1.1 | Check free space map (FSM) |
| pg_prewarm | 1.2 | 1.2 | 1.1 | 1.1 | Provides a convenient way to load data into the OS buffer or PostgreSQL buffer |
| pg_stat_statements | 1.8 | 1.7 | 1.5 | 1.4 | Provides a way to track execution statistics for all SQL statements executed by the server |
| pg_trgm | 1.5 | 1.4 | 1.3 | 1.3 | Provides functions and operators for determining similarity of alphanumeric text, and supports quickly searching for similar strings with index operator classes |
| pgcrypto | 1.3 | 1.3 | 1.3 | 1.3 | Provides cryptographic functions for PostgreSQL |
| pgrowlocks | 1.2 | 1.2 | 1.2 | 1.2 | Provides a function to display row locking information of a specified table |
| pgstattuple | 1.5 | 1.5 | 1.5 | 1.4 | Provides various functions to obtain tuple-level statistics |
| plpgsql | 1.0 | 1.0 | 1.0 | 1.0 | Provides SQL processing language |
| postgis_sfcgal | 3.1.4 | None | 3.1.4 | None | PostGIS SFCGAL spatial geographic information related extension |
| postgis_tiger_geocoder | 2.4.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS TIGER data spatial geographic information related extension |
| postgis_topology | 2.4.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS topology data spatial geographic information related extension |
| postgres_fdw | 1.0 | 1.0 | 1.0 | 1.0 | Cross-database operation table |
| rum | None | 1.3 | 1.3 | 1.3 | High speed full text search |
| sslinfo | None | None | 1.2 | None | Provides information about the SSL certificate provided by the current client |
| tablefunc | 1.0 | 1.0 | 1.0 | 1.0 | Includes multiple return table functions |
| tsm_system_rows | 1.0 | 1.0 | 1.0 | 1.0 | Provides table sampling method SYSTEM_ROWS |
| tsm_system_time | 1.0 | 1.0 | 1.0 | 1.0 | Provides table sampling method SYSTEM_TIME |
| unaccent | 1.1 | 1.1 | 1.1 | 1.1 | Text search dictionary, which removes accents (additional characters) from lexemes |
| zhparser | None | 2.1 | 2.1 | 2.1 | Chinese full text search |
| postgreml | 2.6.0 | 2.6.0 | None | None | PostgreSQL AI plugin |
| pgvector | 0.4.4 | 0.4.4 | None | None | Open source vector similarity search for PostgreSQL |