{"categories":[{"id":10,"name":"TIME","zh_desc":"时间时态扩展：时序数据库 TimescaleDB，时态数据库，版本控制表，定时任务，异步后台任务调度扩展。","en_desc":"TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, ...","count":76},{"id":15,"name":"GIS","zh_desc":"地理空间扩展：PostGIS，地理空间数据类型、函数与索引，天空索引 Q3C，OGR FDW， 寻路算法，地理正/逆查询。","en_desc":"GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc...","count":125},{"id":18,"name":"RAG","zh_desc":"AI与RAG扩展插件：向量数据库，DiskANN 向量索引，相似度度量函数集，库内机器学习与推理 pgml，等等。","en_desc":"Vector Database with Ivfflat, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc... ","count":174},{"id":21,"name":"FTS","zh_desc":"全文检索扩展：ES 替代 pg_search，BM25，中文分词，欧洲语言分词字典 hunspell，模糊检索，2-gram/3-gram 索引。","en_desc":"ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc...","count":122},{"id":24,"name":"OLAP","zh_desc":"分析能力扩展：列式存储，DuckDB与外部数据源包装器，Parquet S3，数据冷热分级存储，分布式计算，透明分片，GPU加速","en_desc":"DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, ...","count":111},{"id":27,"name":"FEAT","zh_desc":"功能特性扩展：图数据库，Hyperloglog，Rum索引，GraphQL，JsonSchema，Hint，虚拟索引，增量物化视图，消息队列等等","en_desc":"OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,...","count":383},{"id":30,"name":"LANG","zh_desc":"存储过程语言扩展：使用各种编程语言开发，调试，打包，分发，测试 PostgreSQL 存储过程：Java，Js，Lua，R，SH，PRQL…","en_desc":"Develop, Test, Package, and Deliver Stored Procedures written in various PL/Languages: Java, Js, Lua, R, Sh, PRQL, ...","count":104},{"id":35,"name":"TYPE","zh_desc":"自定义类型扩展：前缀树，语义版本号，SI单位，位图，无符号整型，高精度数值，有理数，哈希值，IP地址段，球面，RRULE等","en_desc":"Dedicate New Data Types Like: prefix, semver, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more...","count":216},{"id":40,"name":"UTIL","zh_desc":"实用功能扩展：HTTP请求，GZIP压缩，JWT处理，邮件客户端，正则，字符编码，编码解码，加密解密等实用功能","en_desc":"Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,...","count":161},{"id":45,"name":"FUNC","zh_desc":"标识聚合函数：ID生成器，各类聚合函数，摘要函数，数组处理函数，数学函数，统计量，伪随机，等等","en_desc":"Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions...","count":307},{"id":50,"name":"ADMIN","zh_desc":"管理工具扩展：膨胀治理，脏读，检视缓冲区，数据目录，校验和，腐败检查，优先级管理，权限管理，语句准备，限制批量更新等","en_desc":"Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,...","count":229},{"id":60,"name":"STAT","zh_desc":"监控统计扩展：AWR报告，可观测性指标，显示执行计划，查询统计信息，内存使用，配置变更，等待事件采样，慢查询日志，等等","en_desc":"Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc...","count":206},{"id":70,"name":"SEC","zh_desc":"安全功能扩展：强制密码强度，阉割超级用户，密钥管理，商密算法，PII匿名处理，扩展白名单，审计日志，变更追溯，反病毒等等","en_desc":"Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Errors, Extension White List, ...","count":215},{"id":85,"name":"FDW","zh_desc":"外部数据源包装器：FDW开发框架 Wrappers，Multicorn，访问外部的 Mongo，MySQL，SQLite，HDFS，MSSQL，Oracle，DB2，……","en_desc":"Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,...","count":155},{"id":90,"name":"SIM","zh_desc":"数据库兼容扩展：仿真其他 DBMS 的行为：MySQL，Memcache，Mongo，Oracle，Babelfish for Microsoft SQL Server……","en_desc":"Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!","count":51},{"id":95,"name":"ETL","zh_desc":"数据复制扩展：逻辑复制，逻辑解码，DDL复制，JSON/BSON/Protobuf 变更抽取，数据迁移，数据导入，数据比对等","en_desc":"Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,...","count":102}],"counts":{"build_slots":36560,"contrib":74,"docs":2737,"kernel":172,"packaged":625,"packaged_projects":518,"packages":457,"projects":2509,"source_only":1965,"total":2737,"vendor":204},"dimensions":["category","tag","package","kind","lifecycle","license","lang","distribution","repo","pg","os","build","pgrx","capability","docs","relation","vendor","kernel","activity"],"generated":"2026-11-11T22:24:25Z","os":["el8.x86_64","el8.aarch64","el9.x86_64","el9.aarch64","el10.x86_64","el10.aarch64","d12.x86_64","d12.aarch64","d13.x86_64","d13.aarch64","u22.x86_64","u22.aarch64","u24.x86_64","u24.aarch64","u26.x86_64","u26.aarch64"],"pg":[18,17,16,15,14],"server":"pgext"}