postgresql/lightdb主要的extension及客户端工具清单（持续更新）
如果说mysql因为其多引擎架构被人称赞，那么在postgresql中，extension开放性则完全可以说是完胜，而且其生态相比mysql而言，明显不在一个级别。本文维护了postgresql重要的三方extension清单（其中部分原来为三方，在新版本中被纳入到标准发行包中，LightDB集成了绝大部分插件，并修复了整合后的很多缺陷）。
服务端
| 插件名 | 主要用途 | 生产是否推荐默认加载 | 加载模式 | 官网 | 备注（副作用及性能影响） |
| plpgsql_check | 不运行存储过程检查plpgsql的语法错误 | 时 | shared_preload_libraries | https://github.com/okbob/plpgsql_check | https://www.percona.com/blog/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/ |
| pg_hint_plan | 优化器提示插件 | 是 |
pg_hint_plan支持oracle存储纲要的概念，文档中未写，参见https://blog.csdn.net/weixin_39723441/article/details/111662947。 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 |
||
| pg_hexedit | page的pg相关16进制编辑器，比原生hex效果好 | ||||
| postgres_fdw | pg之间的数据库链接，用于替代dblink | 是 | shared_preload_libraries | 虽然fdw在分布式下不如citus，但是很多情况下并不需要citus或者citus限制太多，所以fdw的优化依然很有价值，pg 15的改进https://www.modb.pro/db/436188 | |
| citus | PG分布式层，用于OLTP | 分布式版入门可参考：lightdb分布式版使用入门及性能提升对比 | lightdb canopy基于citus，支持hint下推、distribute by auto自动分布式。相对于原生citus限制更少。 | ||
|
oracle_fdw mysql_fdw file_fdw |
pg到oracle的数据库连接。类似oracle透明网关。 外部表 |
是 |
需要安装oracle客户端。详见https://www.cnblogs.com/zhjh256/p/16213235.html。 lightdb oracle fdw支持多表下推（而不是两个表），支持oracle伪列下推。 |
||
|
ora_migrator |
基于oracle_fdw迁移到postgresql，不能ora2pg简单，迁移表结构可以。 |
https://blog.csdn.net/jycjyc/article/details/128851168 | |||
|
pg_timetable pg_cron pg_dbms_job |
定时任务插件。pg_timetable是cybertec-postgresql开源。 pg_cron属于citus开源。 pg_dbms_job属于ora2pg的一部分。 |
是 |
https://www.cybertec-postgresql.com/en/postgresql-exclusive-cron-jobs-using-pg_timetable-scheduler/ LightDB lt_cron支持一次性任务、秒级调度、时区、linux命令，分布式下调度，最大并发控制，单任务最大并发等特性。 24.x版本也支持dbms_job。 |
||
| pg_repack | 内核开发必备 | 是 | |||
| cstore_fdw | 基于FDW的列式存储，效果一般。citus出品。 | ||||
imcs |
列式存储引擎。新开发存储引擎值得参考，跟mysql上infinidb的做法类似。函数也是自定义的。易用性较差、专用性较强，跟dolphinedb的做法有些类似。 | 否 | https://pgxn.org/dist/imcs/ | ||
zheap |
非稳定版。侵入性太强，源码改动太多，一般人不敢玩。 官方测试，性能不如heap。 |
||||
zedstore |
非稳定版。侵入性太强，源码改动太多，一般人不敢玩。截止2021年12月，三方测试性能不如heap版本。 | https://github.com/greenplum-db/postgres/tree/zedstore | |||
| pgAudit | 生成的审计信息保存在pg标准日志文件中。 | 否 | https://www.pgaudit.org/ |
lightdb自带，22.4默认不开启，之前版本开启。 如果需要较好的可读性的话，需要自己二次开发，保存在单独的文件或表中。 lightdb 24.4增加按照application_name配置，白名单以及黑名单。 |
|
| pg_cheat_funcs | 内核开发必备 | 否 | https://github.com/MasaoFujii/pg_cheat_funcs | ||
| faultinjector | 内核开发必备 | 否 | https://pgconf.in/conferences/pgconfin2020/program/proposals/101 | ||
pageinspect |
以更低级别查看数据库块里面的内容。用于开发调试目的。 可以查看数据块和索引块，值得开发细细研究源码和每个接口，内核开发必备。 |
否 | https://www.postgresql.org/docs/current/pageinspect.html | ||
|
repmgr+keepalived |
专为pg开发的failover扩展和哨兵。citusdata出品。推荐使用repmgr。 | 是 |
https://github.com/citusdata/pg_auto_failover https://pg-auto-failover.readthedocs.io/en/master/index.html |
||
pglogical |
2ndQuadrant（当前是EDB的一部分）从PostgreSQL 9.4开始引入的逻辑复制扩展。作为其BDR的基础。PostgreSQL 10引入了原生扩展之后，其价值大大下降。同步到早期版本可考虑。 但其最大价值是支持DDL |
否 | |||
pg_stat_kcache |
因为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，开箱即用。 | |||
|
解析wal日志为undo，类似oracle logminer | ||||
|
块级恢复工具 | ||||
| pg_show_plan | 查看正在运行的sql的执行计划 |
lightdb修复了一个致命缺陷，默认版本开启后高并发下性能下降90%。 shared_preload_libraries='lt_show_plans'配置后，通过select * from pg_show_plans即可查看，如下：
|
俄罗斯发行版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必备，内核开发必备。 | 是 | https://pgpedia.info/p/pg_filedump.html |
| 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配置和定制版。 |
否 | https://github.com/hslightdb/LightDB-FAQ/wiki/ltloader-mysql%E5%88%B0lightdb%E8%BF%81%E7%A7%BB%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9 |
查询所有安装的插件列表：
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)
https://blog.csdn.net/jycjyc/article/details/128851168
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单，K8s 太复杂？w7panel 让容器管理更轻松！
2020-08-30 生产库ORA-01200 actual file size of x is smaller than correct size of y blocks一例解决
2017-08-30 SaaS的中年危机（转）
2016-08-30 linux查看rpm包创建的所有目录和文件
2016-08-30 mysql=null的优雅解决方法