如果说mysql因为其多引擎架构被人称赞,那么在postgresql中,extension开放性则完全可以说是完胜,而且其生态相比mysql而言,明显不在一个级别。本文维护了postgresql重要的三方extension清单(其中部分原来为三方,在新版本中被纳入到标准发行包中,LightDB集成了绝大部分插件,并修复了整合后的很多缺陷)。
服务端
插件名 | 主要用途 | 生产是否推荐默认加载 | 加载模式 | 官网 | 备注(副作用及性能影响) |
pg_hint_plan | 优化器提示插件 | 是 | | pg_hint_plan支持oracle存储纲要的概念,文档中未写,参见javascript:void(0)。 LightDB lt_hint_plan支持在任何语句块编写任意数量优化器提示,支持qb_name、ordered、no_merge、parallel、use_hash、use_nl、hash_sj、hash_aj等oracle常用提示。详见https://www.hs.net/lightdb/docs/html/pghint_plan.html | |
postgres_fdw | pg之间的数据库链接,用于替代dblink | 是 | shared_preload_libraries | | 虽然fdw在分布式下不如citus,但是很多情况下并不需要citus或者citus限制太多,所以fdw的优化依然很有价值,pg 15的改进https://www.modb.pro/db/436188 |
citus | PG分布式层,用于OLTP | | | | |
oracle_fdw mysql_fdw file_fdw | pg到oracle的数据库连接。类似oracle透明网关。 外部表 | 是 | | | 需要安装oracle客户端。详见javascript:void(0) |
pg_timetable pg_cron pg_dbms_job | 定时任务插件。pg_timetable是cybertec-postgresql开源。 pg_cron属于citus开源。 pg_dbms_job属于ora2pg的一部分。 | 是 | | | LightDB lt_cron支持一次性任务、秒级调度、时区、linux命令,分布式下调度,最大并发控制,单任务最大并发等特性。 |
pg_repack | 内核开发必备 | 是 | | | |
cstore_fdw | 基于FDW的列式存储,效果一般。citus出品。 | | | | |
imcs | 列式存储引擎。新开发存储引擎值得参考,跟mysql上infinidb的做法类似。函数也是自定义的。易用性较差、专用性较强,跟dolphinedb的做法有些类似。 | 否 | | | |
zheap | 非稳定版。侵入性太强,源码改动太多,一般人不敢玩。 官方测试,性能不如heap。 | | | | |
zedstore | 非稳定版。侵入性太强,源码改动太多,一般人不敢玩。截止2021年12月,三方测试性能不如heap版本。 | | | | |
pgAudit | 生成的审计信息保存在pg标准日志文件中。 | 否 | | lightdb自带,22.4默认不开启,之前版本开启。 如果需要较好的可读性的话,需要自己二次开发,保存在单独的文件或表中。 | |
pg_cheat_funcs | 内核开发必备 | 否 | | | |
faultinjector | 内核开发必备 | 否 | | https://pgconf.in/conferences/pgconfin2020/program/proposals/101 | |
| 以更低级别查看数据库块里面的内容。用于开发调试目的。 可以查看数据块和索引块,值得开发细细研究源码和每个接口,内核开发必备。 | 否 | | https://www.postgresql.org/docs/current/pageinspect.html | |
repmgr+keepalived pacemaker+corosync | 专为pg开发的failover扩展和哨兵。citusdata出品。推荐使用repmgr。 | 是 | | https://github.com/citusdata/pg_auto_failover https://pg-auto-failover.readthedocs.io/en/master/index.html | |
| 2ndQuadrant(当前是EDB的一部分)从PostgreSQL 9.4开始引入的逻辑复制扩展。作为其BDR的基础。PostgreSQL 10引入了原生扩展之后,其价值大大下降。同步到早期版本可考虑。 但其最大价值是支持DDL | 否 | | | |
| 因为pg默认不支持直接I/O,利用了pagecache,故本扩展统计物理I/O。 | 否 | | | lightdb 22.4默认自带,但未开启。 |
pg_profile pg_wait_sampling | 较弱。LightDB发行版极大的增强了等待事件的准确性,各TOP SQL精确性,内核参数集成等。 | | | | lightdb pwr基于pg_profile,对此进行大幅度的重构和改进,精确性和稳定性都有很大的提升,lt_profile。用户可直接下载lightdb代替postgresql,开箱即用。 |
walminer | 解析wal日志为undo,类似oracle logminer | | | | |
pg_lightool | 块级恢复工具 | | | | https://github.com/HighgoSoftware/pg_lightool javascript:void(0) |
| | | | | |
俄罗斯发行版pg自带的插件列表 https://postgrespro.com/docs/postgrespro/13/contrib,效果很差、缺陷很多。
独立工具
工具名 | 用途 | 生产是否推荐默认包含 | 官网 |
pg_bulkload | 数据导入工具。DBA和开发必备。 LightDB lt_bulkload/copy支持多个字符作为分隔符,含特殊字符,迁移更遍便利。 | 是 | https://github.com/ossc-db/pg_bulkload/releases/tag/VERSION3_1_17 |
pg_rewind pg_resetwal | 备库初始数据同步软件。DBA必备 wal误删修复软件,不同于oracle需要resetlog比较复杂,pg实现简单,但本质上timelineid也是增加了。 | 是 | https://www.postgresql.org/docs/current/app-pgrewind.html |
pg_filedump | 数据文件dump工具,用于异常恢复。DBA必备,内核开发必备。 | 是 | |
pgcenter | pg top命令行工具,类似于nmon,效果远比mysql的inntop佳 | 是 | |
pgpool-II(主打读写分离)/pgbouncer(主打连接池) | 亚秒级中间件连接池代理,适用于对延时不高度敏感(比如关心快慢2-3毫秒)、同时数据库连接并发特别多的情况,比如微服务很多的架构。和pgbouncer是竞争关系。 pgpool和pgbouncer都不推荐,超大并发连接建议使用postgresql 14+。低版本的话,前置pgbouncer降低连接,后面挂pgpool做读写分离和负载均衡。 https://www.pgpool.net/docs/pgpool-II-3.2.1/tutorial-zh_cn.html 连接池整体效果都一般,可以参见 https://www.enterprisedb.com/blog/pgpool-vs-pgbouncer https://severalnines.com/blog/guide-using-pgbouncer/ https://blog.pythian.com/comparing-pgpool-ii-and-pgbouncer/。 | 否 | https://www.pgpool.net/pgpool-web/contrib_docs/pgpool-II_for_beginners.pdf |
ora2pg | oracle到postgresql迁移,适用于测试、开发以及初始生产迁移。 因为有特殊字段类型存在,推荐lightdb配置和定制版。 | 否 | |
pgloader | mysql到postgresql迁移,适用于测试、开发以及初始生产迁移。 因为有特殊字段类型如rum存在,推荐lightdb配置和定制版。 | 否 |
查询所有安装的插件列表:
lightdb@lt_test=# select * from pg_extension;
oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
---------+--------------------+----------+--------------+----------------+------------+-----------+--------------
14168 | plpgsql | 10 | 11 | f | 1.0 | |
14173 | plorasql | 10 | 11 | f | 1.1 | |
16385 | lt_show_plans | 10 | 16384 | t | 1.0 | |
16393 | lt_standby_forward | 10 | 16384 | f | 1.0 | |
16394 | lt_stat_statements | 10 | 16384 | t | 1.8 | |
16408 | uuid-ossp | 10 | 16384 | t | 1.1 | |
16422 | lt_prewarm | 10 | 16384 | t | 1.3 | |
16426 | lt_buffercache | 10 | 16384 | t | 1.3 | |
16432 | pageinspect | 10 | 16384 | t | 1.8 | |
16464 | tablefunc | 10 | 16384 | t | 1.0 | |
16486 | lt_hint_plan | 10 | 16485 | f | 1.3.7 | |
16499 | ltfincore | 10 | 16384 | t | 1.2 | |
16514 | orafce | 10 | 16384 | f | 3.19 | |
18770 | ltaudit | 10 | 16384 | t | 1.5 | |
18775 | lt_tempfile | 10 | 16384 | t | 1.0 | |
18778 | lt_log_long_xact | 10 | 16384 | f | 1.1 | |
18783 | lt_bulkload | 10 | 16384 | f | 1.0 | |
18786 | zhparser | 10 | 16384 | t | 2.1 | |
18807 | rum | 10 | 16384 | t | 1.3 | |
19430 | tsvector2 | 10 | 16384 | f | 1.0 | |
19585 | myfce | 10 | 16384 | t | 1.1 | |
19709 | lt_stat_activity | 10 | 16384 | t | 1.1 | |
19791 | lt_sm | 10 | 16384 | t | 1.0 | |
19823 | lt_ope | 10 | 16384 | t | 1.0 | |
4091553 | ltfce | 10 | 2200 | f | 1.0 | |
(25 rows)
lightdb@lt_test=# select * from pg_available_extensions;
name | default_version | installed_version | comment
-----------------------+-----------------+-------------------+-----------------------------------------------------------------------------------------------
lt_log_long_xact | 1.1 | 1.1 | pl/pgsql function to log long running transactions
orafce | 3.19 | 3.19 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
lt_show_plans | 1.0 | 1.0 | show query plans of all currently running SQL statements
myfce | 1.1 | 1.1 | Functions and operators that emulate a subset of functions from the Mysql RDBMS
lt_proctab | 0.0.9 | | Access operating system process table
tcn | 1.0 | | Triggered change notifications
uuid-ossp | 1.1 | 1.1 | Generate universally unique identifiers (UUIDs)
dict_int | 1.0 | | text search dictionary template for integers
system_stats | 1.1 | | System statistic functions for LightDB
lt_freespacemap | 1.2 | | examine the free space map (FSM)
plorasql | 1.1 | 1.1 | PL/oraSQL procedural language
ltree | 1.2 | | data type for hierarchical tree-like structures
fuzzystrmatch | 1.1 | | determine similarities and distance between strings
earthdistance | 1.1 | | calculate great-circle distances on the surface of the Earth
hstore | 1.7 | | data type for storing sets of (key, value) pairs
lt_profile | 0.3.6 | | LightDB load profile repository and report builder
ltfce | 1.0 | 1.0 | Functions and operators that emulate a subset of functions from the lt_catalog
lo | 1.1 | | Large Object maintenance
ltrowlocks | 1.2 | | show row-level locking information
dict_xsyn | 1.0 | | text search dictionary template for extended synonym processing
adminpack | 2.1 | | administrative functions for PostgreSQL
intarray | 1.3 | | functions, operators, and index support for 1-D arrays of integers
wal2sql | 1.0 | | wal2sql
citext | 1.6 | | data type for case-insensitive character strings
tsm_system_rows | 1.0 | | TABLESAMPLE method which accepts number of rows as a limit
bloom | 1.0 | | bloom access method - signature file based index
lt_visibility | 1.2 | | examine the visibility map (VM) and page-level visibility info
dblink | 1.2 | | Connect to other LightDB databases from within a database
tsm_system_time | 1.0 | | TABLESAMPLE method which accepts time in milliseconds as a limit
lt_sm | 1.0 | 1.0 | sm encrypt/decrypt for LightDB
cube | 1.4 | | data type for multidimensional cubes
unaccent | 1.1 | | text search dictionary that removes accents
ltstattuple | 1.5 | | show tuple-level statistics
lt_bulkload | 1.0 | 1.0 | lt_bulkload is a high speed data loading utility for LightDB
seg | 1.3 | | data type for representing line segments or floating-point intervals
rum | 1.3 | 1.3 | RUM index access method
ltaudit | 1.5 | 1.5 | Provides auditing functionality
btree_gist | 1.5 | | support for indexing common datatypes in GiST
btree_gin | 1.3 | | support for indexing common datatypes in GIN
lt_ope | 1.0 | 1.0 | Order-Preserving Encryption for LightDB
lt_buffercache | 1.3 | 1.3 | examine the shared buffer cache
oracle_fdw | 1.2 | | foreign data wrapper for Oracle access
canopy_columnar | 11.1-1 | | Canopy Columnar extension
postgres_fdw | 1.0 | | foreign-data wrapper for remote PostgreSQL servers
lt_statement_rollback | 1.0 | | statement-level rollback
xml2 | 1.1 | | XPath querying and XSLT
lt_cron | 1.5 | | Job scheduler for LightDB
lt_tempfile | 1.0 | 1.0 | some functions for Managing temporary files
lt_stat_activity | 1.1 | 1.1 | lt_stat_activity
ltfincore | 1.2 | 1.2 | Examine and manage the os buffer cache
file_fdw | 1.0 | | foreign-data wrapper for flat file access
ltcluster | 5.2 | | Cluster for LightDB
lt_pathman | 1.5 | | Partitioning tool for PostgreSQL
insert_username | 1.0 | | functions for tracking who changed a table
lt_standby_forward | 1.0 | 1.0 | Standby forward DML to primary
sslinfo | 1.2 | | information about SSL certificates
autoinc | 1.0 | | functions for autoincrementing fields
intagg | 1.1 | | integer aggregator and enumerator (obsolete)
pageinspect | 1.8 | 1.8 | inspect the contents of database pages at a low level
lt_trgm | 1.5 | | text similarity measurement and index searching based on trigrams
refint | 1.0 | | functions for implementing referential integrity (obsolete)
tsvector2 | 1.0 | 1.0 | tsvector2 - extended format of tsvector
amcheck | 1.2 | | functions for verifying relation integrity
lt_hint_plan | 1.3.7 | 1.3.7 | Controls execution plan with hinting phrases in comment of special form
lt_qualstats | 2.0.3 | | An extension collecting statistics about quals
lt_cheat_funcs | 1.0 | | provides cheat (but useful) functions
ltcrypto | 1.3 | | cryptographic functions
isn | 1.2 | | data types for international product numbering standards
mysql_fdw | 1.1 | | Foreign data wrapper for querying a MySQL server
canopy | 11.1-1 | | canopy distributed database
zhparser | 2.1 | 2.1 | a parser for full-text search of Chinese
tablefunc | 1.0 | 1.0 | Functions that manipulate whole tables, including crosstab
moddatetime | 1.0 | | functions for tracking last modification time
lt_prewarm | 1.3 | 1.3 | prewarm relation data
lt_stat_statements | 1.8 | 1.8 | Track planning and execution statistics of all SQL statements executed
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
(76 rows)
lightdb@lt_test=# select * from pg_available_extension_versions;
name | version | installed | superuser | trusted | relocatable | schema | requires | comment
-----------------------+---------+-----------+-----------+---------+-------------+------------+----------------------+-------------------------------------------------------------------------
----------------------
lt_log_long_xact | 1.0 | f | f | f | f | | {plpgsql} | pl/pgsql function to log long running transactions
lt_log_long_xact | 1.1 | t | f | f | f | | {plpgsql} | pl/pgsql function to log long running transactions
orafce | 3.17 | f | t | f | f | | {uuid-ossp} | Functions and operators that emulate a subset of functions and packages
from the Oracle RDBMS
orafce | 3.18 | f | t | f | f | | {uuid-ossp} | Functions and operators that emulate a subset of functions and packages
from the Oracle RDBMS
orafce | 3.19 | t | t | f | f | | {uuid-ossp} | Functions and operators that emulate a subset of functions and packages
from the Oracle RDBMS
lt_show_plans | 1.0 | t | t | f | t | | | show query plans of all currently running SQL statements
myfce | 1.0 | f | t | t | t | | | Functions and operators that emulate a subset of functions from the Mysq
l RDBMS
myfce | 1.1 | t | t | t | t | | | Functions and operators that emulate a subset of functions from the Mysq
l RDBMS
lt_proctab | 0.0.9 | f | t | f | t | | | Access operating system process table
tcn | 1.0 | f | t | t | t | | | Triggered change notifications
uuid-ossp | 1.1 | t | t | t | t | | | Generate universally unique identifiers (UUIDs)
dict_int | 1.0 | f | t | t | t | | | text search dictionary template for integers
system_stats | 1.1 | f | t | f | t | | | System statistic functions for LightDB
system_stats | 1.0 | f | t | f | t | | | System statistic functions for LightDB
lt_freespacemap | 1.1 | f | t | f | t | | | examine the free space map (FSM)
lt_freespacemap | 1.2 | f | t | f | t | | | examine the free space map (FSM)
plorasql | 1.0 | f | t | t | f | pg_catalog | | PL/oraSQL procedural language
plorasql | 1.1 | t | t | t | f | pg_catalog | | PL/oraSQL procedural language
ltree | 1.1 | f | t | t | t | | | data type for hierarchical tree-like structures
ltree | 1.2 | f | t | t | t | | | data type for hierarchical tree-like structures
fuzzystrmatch | 1.1 | f | t | t | t | | | determine similarities and distance between strings
earthdistance | 1.1 | f | t | f | t | | {cube} | calculate great-circle distances on the surface of the Earth
hstore | 1.4 | f | t | t | t | | | data type for storing sets of (key, value) pairs
hstore | 1.5 | f | t | t | t | | | data type for storing sets of (key, value) pairs
hstore | 1.6 | f | t | t | t | | | data type for storing sets of (key, value) pairs
hstore | 1.7 | f | t | t | t | | | data type for storing sets of (key, value) pairs
lt_profile | 0.3.6 | f | f | f | f | | {dblink,plpgsql} | LightDB load profile repository and report builder
ltfce | 1.0 | t | t | f | f | | | Functions and operators that emulate a subset of functions from the lt_c
atalog
lo | 1.1 | f | t | t | t | | | Large Object maintenance
ltrowlocks | 1.2 | f | t | f | t | | | show row-level locking information
dict_xsyn | 1.0 | f | t | f | t | | | text search dictionary template for extended synonym processing
adminpack | 1.0 | f | t | f | f | pg_catalog | | administrative functions for PostgreSQL
adminpack | 2.0 | f | t | f | f | pg_catalog | | administrative functions for PostgreSQL
adminpack | 2.1 | f | t | f | f | pg_catalog | | administrative functions for PostgreSQL
adminpack | 1.1 | f | t | f | f | pg_catalog | | administrative functions for PostgreSQL
intarray | 1.2 | f | t | t | t | | | functions, operators, and index support for 1-D arrays of integers
intarray | 1.3 | f | t | t | t | | | functions, operators, and index support for 1-D arrays of integers
citext | 1.4 | f | t | t | t | | | data type for case-insensitive character strings
citext | 1.5 | f | t | t | t | | | data type for case-insensitive character strings
citext | 1.6 | f | t | t | t | | | data type for case-insensitive character strings
tsm_system_rows | 1.0 | f | t | t | t | | | TABLESAMPLE method which accepts number of rows as a limit
bloom | 1.0 | f | t | f | t | | | bloom access method - signature file based index
lt_visibility | 1.1 | f | t | f | t | | | examine the visibility map (VM) and page-level visibility info
lt_visibility | 1.2 | f | t | f | t | | | examine the visibility map (VM) and page-level visibility info
dblink | 1.2 | f | t | f | t | | | Connect to other LightDB databases from within a database
tsm_system_time | 1.0 | f | t | t | t | | | TABLESAMPLE method which accepts time in milliseconds as a limit
lt_sm | 1.0 | t | t | f | t | | | sm encrypt/decrypt for LightDB
cube | 1.2 | f | t | t | t | | | data type for multidimensional cubes
cube | 1.3 | f | t | t | t | | | data type for multidimensional cubes
cube | 1.4 | f | t | t | t | | | data type for multidimensional cubes
unaccent | 1.1 | f | t | t | t | | | text search dictionary that removes accents
ltstattuple | 1.4 | f | t | f | t | | | show tuple-level statistics
ltstattuple | 1.5 | f | t | f | t | | | show tuple-level statistics
lt_bulkload | 1.0 | t | t | f | f | | | lt_bulkload is a high speed data loading utility for LightDB
seg | 1.1 | f | t | t | t | | | data type for representing line segments or floating-point intervals
seg | 1.2 | f | t | t | t | | | data type for representing line segments or floating-point intervals
seg | 1.3 | f | t | t | t | | | data type for representing line segments or floating-point intervals
rum | 1.3 | t | t | f | t | | | RUM index access method
rum | 1.0 | f | t | f | t | | | RUM index access method
rum | 1.2 | f | t | f | t | | | RUM index access method
rum | 1.1 | f | t | f | t | | | RUM index access method
ltaudit | 1.5 | t | t | f | t | | | Provides auditing functionality
btree_gist | 1.2 | f | t | t | t | | | support for indexing common datatypes in GiST
btree_gist | 1.4 | f | t | t | t | | | support for indexing common datatypes in GiST
btree_gist | 1.5 | f | t | t | t | | | support for indexing common datatypes in GiST
btree_gist | 1.3 | f | t | t | t | | | support for indexing common datatypes in GiST
btree_gin | 1.0 | f | t | t | t | | | support for indexing common datatypes in GIN
btree_gin | 1.1 | f | t | t | t | | | support for indexing common datatypes in GIN
btree_gin | 1.2 | f | t | t | t | | | support for indexing common datatypes in GIN
btree_gin | 1.3 | f | t | t | t | | | support for indexing common datatypes in GIN
lt_ope | 1.0 | t | t | f | t | | | Order-Preserving Encryption for LightDB
lt_buffercache | 1.2 | f | t | f | t | | | examine the shared buffer cache
lt_buffercache | 1.3 | t | t | f | t | | | examine the shared buffer cache
oracle_fdw | 1.2 | f | t | f | t | | | foreign data wrapper for Oracle access
canopy_columnar | 11.1-1 | f | t | f | f | pg_catalog | | Canopy Columnar extension
canopy_columnar | 11.1-0 | f | t | f | f | pg_catalog | | Canopy Columnar extension
postgres_fdw | 1.0 | f | t | f | t | | | foreign-data wrapper for remote PostgreSQL servers
lt_statement_rollback | 1.0 | f | t | t | t | | | statement-level rollback
xml2 | 1.1 | f | t | f | f | | | XPath querying and XSLT
lt_cron | 1.0 | f | t | f | f | | | Job scheduler for LightDB
lt_cron | 1.2 | f | t | f | f | | | Job scheduler for LightDB
lt_cron | 1.3 | f | t | f | f | | | Job scheduler for LightDB
lt_cron | 1.1 | f | t | f | f | | | Job scheduler for LightDB
lt_cron | 1.4 | f | t | f | f | | | Job scheduler for LightDB
lt_cron | 1.5 | f | t | f | f | | | Job scheduler for LightDB
lt_tempfile | 1.0 | t | t | t | t | | | some functions for Managing temporary files
lt_stat_activity | 1.0 | f | t | f | t | | {lt_stat_statements} | lt_stat_activity
lt_stat_activity | 1.1 | t | t | f | t | | {lt_stat_statements} | lt_stat_activity
ltfincore | 1.2 | t | t | f | t | | | Examine and manage the os buffer cache
file_fdw | 1.0 | f | t | f | t | | | foreign-data wrapper for flat file access
ltcluster | 4.2 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 4.3 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 5.2 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 4.4 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 4.1 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 5.0 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 4.0 | f | t | f | f | ltcluster | | Cluster for LightDB
ltcluster | 5.1 | f | t | f | f | ltcluster | | Cluster for LightDB
lt_pathman | 1.5 | f | t | f | f | | | Partitioning tool for PostgreSQL
insert_username | 1.0 | f | t | f | t | | | functions for tracking who changed a table
lt_standby_forward | 1.0 | t | t | f | f | | | Standby forward DML to primary
sslinfo | 1.2 | f | t | f | t | | | information about SSL certificates
autoinc | 1.0 | f | t | f | t | | | functions for autoincrementing fields
intagg | 1.1 | f | t | f | t | | | integer aggregator and enumerator (obsolete)
pageinspect | 1.5 | f | t | f | t | | | inspect the contents of database pages at a low level
pageinspect | 1.6 | f | t | f | t | | | inspect the contents of database pages at a low level
pageinspect | 1.7 | f | t | f | t | | | inspect the contents of database pages at a low level
pageinspect | 1.8 | t | t | f | t | | | inspect the contents of database pages at a low level
lt_trgm | 1.3 | f | t | t | t | | | text similarity measurement and index searching based on trigrams
lt_trgm | 1.4 | f | t | t | t | | | text similarity measurement and index searching based on trigrams
lt_trgm | 1.5 | f | t | t | t | | | text similarity measurement and index searching based on trigrams
refint | 1.0 | f | t | f | t | | | functions for implementing referential integrity (obsolete)
tsvector2 | 1.0 | t | t | f | f | lt_catalog | | tsvector2 - extended format of tsvector
amcheck | 1.0 | f | t | f | t | | | functions for verifying relation integrity
amcheck | 1.1 | f | t | f | t | | | functions for verifying relation integrity
amcheck | 1.2 | f | t | f | t | | | functions for verifying relation integrity
lt_hint_plan | 1.3.7 | t | t | f | f | hint_plan | | Controls execution plan with hinting phrases in comment of special form
lt_qualstats | 2.0.3 | f | t | f | t | | | An extension collecting statistics about quals
lt_cheat_funcs | 1.0 | f | t | f | t | | | provides cheat (but useful) functions
ltcrypto | 1.3 | f | t | t | t | | | cryptographic functions
isn | 1.1 | f | t | t | t | | | data types for international product numbering standards
isn | 1.2 | f | t | t | t | | | data types for international product numbering standards
mysql_fdw | 1.1 | f | t | f | t | | | Foreign data wrapper for querying a MySQL server
mysql_fdw | 1.0 | f | t | f | t | | | Foreign data wrapper for querying a MySQL server
canopy | 8.0-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.0-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.0-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.1-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.2-3 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.2-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.2-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.2-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-5 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-6 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.1-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.2-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-3 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.5-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.5-3 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-8 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-9 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-11 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-12 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.2-5 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-13 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-7 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 11.0-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 11.1-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.4-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.4-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 11.0-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 11.0-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.2-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.2-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.0-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.2-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.3-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.2-2 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.5-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.2-4 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.3-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 9.4-3 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.2-3 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 10.1-1 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 8.0-10 | f | t | f | f | pg_catalog | | canopy distributed database
canopy | 11.0-3 | f | t | f | f | pg_catalog | | canopy distributed database
zhparser | 2.0 | f | t | f | t | | | a parser for full-text search of Chinese
zhparser | 2.1 | t | t | f | t | | | a parser for full-text search of Chinese
zhparser | 1.0 | f | t | f | t | | | a parser for full-text search of Chinese
tablefunc | 1.0 | t | t | t | t | | | Functions that manipulate whole tables, including crosstab
moddatetime | 1.0 | f | t | f | t | | | functions for tracking last modification time
lt_prewarm | 1.1 | f | t | f | t | | | prewarm relation data
lt_prewarm | 1.2 | f | t | f | t | | | prewarm relation data
lt_prewarm | 1.3 | t | t | f | t | | | prewarm relation data
lt_stat_statements | 1.4 | f | t | f | t | | | Track planning and execution statistics of all SQL statements executed
lt_stat_statements | 1.6 | f | t | f | t | | | Track planning and execution statistics of all SQL statements executed
lt_stat_statements | 1.7 | f | t | f | t | | | Track planning and execution statistics of all SQL statements executed
lt_stat_statements | 1.5 | f | t | f | t | | | Track planning and execution statistics of all SQL statements executed
lt_stat_statements | 1.8 | t | t | f | t | | | Track planning and execution statistics of all SQL statements executed
plpgsql | 1.0 | t | t | t | f | pg_catalog | | PL/pgSQL procedural language
(182 rows)
LightDB Enterprise Postgres--金融级关系型数据库,更快、更稳、更懂金融!