num_stat_col，控制文件内统计列数，为每个 JANM 文件节省 CPU 和元数据大小。默认值为 32，与 INDEX_MAX_KEYS 相同。 ## • 外表 FDW 相关 新增 raw_fdw 外表接口，支持在协调节点和工作节点上执行，以原始字节（byte）读取文件。 为外表启用部分聚合能力，支持并行聚集下推。 新增 fdb max retry（替代原 MaxRetry 功能），默认值设置为 50。 ## autovacuum 清理孤立的临时表。 ## • pgaudit 插件 支持使用 pgaudit 插件生成审计日志。 ## • Kafka 接口 ☑ 支持获取 Kafka FDW 统计数据。 ☑ Kafka FDW 支持 JSON 格式。 ## 执行计划信息 支持在 EXPLAIN ANALYZE VERbose 执行结果中显示调度相关状态信息。 ## • 用户定义函数 UDF 新增

remote data ### PostgreSQL 9.6 FDW improvements • postgres_fdw is a Foreign Data Wrapper to access remote PostgreSQL instances from within PostgreSQL - In 9.6 postgres_fdw now supports pushing down remote Postgres-XL ## More About postgres_fdw ## postgres_fdw example CREATE EXTENSION "postgres_fdw"; CREATE SERVER pg_ch FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '127.0.0.1', port SERVER pg_ch OPTIONS (user 'msharp'); CREATE SERVER pg_us FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '127.0.0.1', port '35434', dbname 'test1'); CREATE USER MAPPING

12. dict_int ..... 2515 F.13. dict_xsyn ..... 2516 F.14. earthdistance ..... 2517 F.15. file_fdw ..... 2519 F.16. fuzzystrmatch ..... 2521 F.17. hstore ..... 2524 F.18. intagg ..... 2531 F pgstattuple ..... 2575 F.32. pg_trgm ..... 2580 F.33. pg_visibility ..... 2585 F.34. postgres_fdw ..... 2586 F.35. seg ..... 2592 F.36. sepgsql ..... 2595 F.37. spi ..... 2603 F.38. sslinfo language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |index\_am\_handler|An index access method handler is declared

12. dict_int ..... 2392 F.13. dict_xsyn ..... 2392 F.14. earthdistance ..... 2394 F.15. file_fdw ..... 2396 F.16. fuzzystrmatch ..... 2398 F.17. hstore ..... 2400 F.18. intagg ..... 2407 F pgstattuple ..... 2449 F.32. pg_trgm ..... 2453 F.33. pg_visibility ..... 2457 F.34. postgres_fdw ..... 2459 F.35. seg ..... 2464 F.36. sepgsql ..... 2467 F.37. spi ..... 2475 F.38. sslinfo language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |index\_am\_handler|An index access method handler is declared

13. dict_int ..... 2825 F.14. dict_xsyn ..... 2826 F.15. earthdistance ..... 2827 F.16. file_fdw ..... 2829 F.17. fuzzystmatch ..... 2832 F.18. hstore ..... 2835 F.19. intagg ..... 2843 F pg_trgm ..... 2902 F.36. pg_visibility ..... 2908 F.37. pg_walinspect ..... 2909 F.38. postgres_fdw ..... 2911 F.39. seg ..... 2921 F.40. sepgsql ..... 2924 F.41. spi ..... 2933 F.42. sslinfo language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |table\_am\_handler|A table access method handler is declared

dictionary ..... 2857 F.15. earthdistance — calculate great-circle distances ..... 2859 F.16. file_fdw — access data files in the server's file system ..... 2861 F.17. fuzzystrmatch — determine string and utilities ..... 2956 F.37. pg_walinspect — low-level WAL inspection ..... 2958 F.38. postgres_fdw — access data stored in external PostgreSQL servers ..... 2962 F.39. seg — a datatype for line segments language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |table\_am\_handler|A table access method handler is declared

Callback Routines ..... 2110 55.2.1. FDW Routines For Scanning Foreign Tables ..... 2110 55.2.2. FDW Routines For Scanning Foreign Joins ..... 2113 55.2.3. FDW Routines For Planning Post-Scan/Join ... 2113 55.2.4. FDW Routines For Updating Foreign Tables ..... 2114 55.2.5. FDW Routines For Row Locking ..... 2118 55.2.6. FDW Routines for EXPLAIN ..... 2120 55.2.7. FDW Routines for ANALYZE ANALYZE ..... 2120 55.2.8. FDW Routines For IMPORT FOREIGN SCHEMA ..... 2121 55.2.9. FDW Routines for Parallel Execution ..... 2122 55.3. Foreign Data Wrapper Helper Functions ..... 2122 55.4. Foreign

dictionary ..... 2713 F.15. earthdistance — calculate great-circle distances ..... 2715 F.16. file_fdw — access data files in the server's file system ..... 2717 F.17. fuzzystrmatch — determine string and utilities ..... 2808 F.37. pg_walspect — low-level WAL inspection ..... 2810 F.38. postgres_fdw — access data stored in external PostgreSQL servers ..... 2814 F.39. seg — a datatype for line segments language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |table\_am\_handler|A table access method handler is declared

11. dict_int ..... 2787 F.12. dict_xsyn ..... 2788 F.13. earthdistance ..... 2789 F.14. file_fdw ..... 2791 F.15. fuzzystrmatch ..... 2794 F.16. hstore ..... 2797 F.17. intagg ..... 2805 F pg_surgery ..... 2863 F.33. pg_trgm ..... 2865 F.34. pg_visibility ..... 2871 F.35. postgres_fdw ..... 2872 F.36. seg ..... 2881 F.37. sepgsql ..... 2884 F.38. spi ..... 2892 F.39. sslinfo language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |table\_am\_handler|A table access method handler is declared

11. dict_int ..... 2641 F.12. dict_xsyn ..... 2642 F.13. earthdistance ..... 2643 F.14. file_fdw ..... 2645 F.15. fuzzystrmatch ..... 2647 F.16. hstore ..... 2650 F.17. intagg ..... 2657 F pg_surgery ..... 2713 F.33. pg_trgm ..... 2714 F.34. pg_visibility ..... 2720 F.35. postgres_fdw ..... 2721 F.36. seg ..... 2729 F.37. sepgsql ..... 2732 F.38. spi ..... 2740 F.39. sslinfo language call handler is declared to return language\_handler.| |fdw\_handler|A foreign-data wrapper handler is declared to return fdw\_handler.| |table\_am\_handler|A table access method handler is declared