发展路线

• 1: 待办清单
• 2: 缺陷案例
• 3: 变更日志

1 - 待办清单

Resource

• PGXN: Recent
• PGRPMS
• PGDEBS
• 1000+ PG Extension Gist

Doing

Nope

Candidate

• dsef
• pg_mustach 1.0.0
• is_jsonb_valid https://github.com/furstenheim/is_jsonb_valid
• pg_kafka https://github.com/xstevens/pg_kafka
• pg_jieba https://github.com/jaiminpan/pg_jieba
• OneSparse https://github.com/OneSparse/OneSparse
• PipelineDB https://github.com/pipelinedb/pipelinedb
• SQL Firewall https://github.com/uptimejp/sql_firewall
• zcurve https://github.com/bmuratshin/zcurve
• PG dot net https://github.com/Brick-Abode/pldotnet/releases
• pg_scws: https://github.com/jaiminpan/pg_scws
• themsis: https://github.com/cossacklabs/pg_themis
• pgspeck https://github.com/johto/pgspeck
• lsm3 https://github.com/postgrespro/lsm3
• monq https://github.com/postgrespro/monq
• pg_badplan https://github.com/trustly/pg_badplan
• pg_recall https://github.com/mreithub/pg_recall
• pgfsm https://github.com/michelp/pgfsm
• pg_trgm pro https://github.com/postgrespro/pg_trgm_pro
• weighted_mean https://github.com/Kozea/weighted_mean
• kmeans https://github.com/umitanuki/kmeans-postgresql

Not Planned

• pg_top: not ready due to cmake error
• pg_quack, we already have a pg_lakehouse
• pg_telemetry, we already have better observability
• pgx_ulid, https://github.com/pksunkara/pgx_ulid, already covered by pg_idkit (MIT, but RUST)
• embedding: obsolete
• zson https://github.com/postgrespro/zson MIT C (too old)
• pghydro https://github.com/pghydro/pghydro C GPL-2.0 6.6 (no makefile)
• pg_natural_sort_order https://github.com/Zeleo/pg_natural_sort_order (too old)
• pg_query_state https://github.com/postgrespro/pg_query_state
• pgsampler https://github.com/no0p/pgsampler
• pg_lz4 https://github.com/zilder/pg_lz4
• pg_amqp https://github.com/omniti-labs/pg_amqp
• tinyint https://github.com/umitanuki/tinyint-postgresql
• pg_blkchain https://github.com/blkchain/pg_blkchain
• hashtypes https://github.com/pandrewhk/hashtypes
• foreign_table_exposer https://github.com/komamitsu/foreign_table_exposer
• ldap_fdw https://github.com/guedes/ldap_fdw
• pg_backtrace https://github.com/postgrespro/pg_backtrace (only works on PG12)
• connection_limits https://github.com/tvondra/connection_limits
• fixeddecimal https://github.com/2ndQuadrant/fixeddecimal
• fuzzywuzzy https://github.com/hooopo/pg-fuzzywuzzy
• pg_paxos https://github.com/microsoft/pg_paxos

Retired

• parquet_s3_fdw: retired due to too much duckdb better alternatives
• pg_tier: retired due to parquet_s3_fdw deps
• pg_mon: retired due to pg17 in-compatibility
• pg_search: retired due to moving to official release procedure
• pg_bm25: retired due to renaming to pg_search
• pg_analytics: retired due to moving to official release procedure, and once renaming to pg_lakehouse
• pg_lakehouse: retired due to renaming back to pg_analytics
• pg_sparse: retired due to merge into pgvector, and no longer maintained
• mysqlcompat: retire due to conflict func with higher version of PG
• pg_comparator: retired due to removing from PGDG repo
• pg_proctab: retired due to covered by pgnodemx
• pg_statviz: broken deps and replaceable functionality
• pg_net : retired due to moving into PGDG repo
• pg_tle : retired due to moving into PGDG repo
• pg_bigm : retired due to moving into PGDG repo
• pgsql-http : retired due to moving into PGDG repo
• pgsql-gzip : retired due to moving into PGDG repo
• pg_dirtyread : retired due to moving into PGDG repo
• pointcloud : retired due to moving into PGDG repo
• pg_top: retired due to too much trouble
• pg_timeit: retired due incompatible on arm64
• vacuumlo & oid2name: binary command, actually they are not extensions
• pgdd: remove due to not actively maintained and legacy pgrx version

2 - 缺陷案例

典型缺陷

• pg_duckdb el8:*:*
• pljava: el8:*:*
• pllua: el8:arm:13,14,15
• h3: el8.amd.pg17
• jdbc_fdw: el:arm:*
• pg_partman: u24:*:13
• wiltondb: d12:*:*
• citus and hydra are mutually exclusive
• pg_duckdb and pg_mooncake are mutually exclusive
• pg_duckdb will invalidate duckdb_fdw
• documentdb_core is not available on arm arch
• vchord 0.2+ is not available on d12/u22 (0.1 available)

PG17支持

以下扩展插件尚未支持 PostgreSQL：

• age ：Ubuntu 24 已有部分支持
• plprql
• hydra
• upid: wait on pg17 https://github.com/carderne/upid/issues
• pg_kaboom
• pg_tde
• jdbc_fdw
• db2_fdw
• mongo_fdw
• kafka_fdw
• wal2mongo
• logfmt
• wiltondb

缺少开源协议

以下扩展插件尚未提供开源协议：

• jsonb_apply 0.1.0

缺少RPM包

以下扩展为 Debian 系统独有，需要移植到 EL 系统中：

• mobilitydb
• rdkit
• hstore_pllua
• hstore_plluau
• debversion
• pg_rrule

缺少DEB包

以下扩展为 EL 系统独有，需要移植到 Debian 系统中：

• pg_strom
• faker
• dbt2
• pg_top
• multicorn
• odbc_fdw
• jdbc_fdw
• tds_fdw
• db2_fdw
• sqlite_fdw
• pgbouncer_fdw
• mongo_fdw
• hdfs_fdw
• pg_dbms_metadata
• pg_dbms_lock
• pg_dbms_job

3 - 变更日志

2025-02-22

• documentdb 0.101-0
• pgcollection (new) 0.9.1
• pg_bzip (new) 1.0.0
• pg_net 0.14.0
• pg_curl 2.4.2
• vault 0.3.1 (become C)
• table_version 1.10.3 -> 1.11.0
• pg_duration 1.0.2
• timescaledb 2.18.2
• pg_analytics 0.3.4
• pg_search 0.15.2
• pg_graphql 1.5.11
• vchord 0.1.1 -> 0.2.1 ((+13))
• vchord_bm25 0.1.0 -> 0.1.1
• pg_mooncake 0.1.1 -> 0.1.2
• pg_duckdb 0.2.0 -> 0.3.1
• pgddl 0.29
• pgsql_tweaks 0.11.0

2025-02-10

• citus 13.0.0 -> 13.0.1
• pg_mooncake 0.1.0 -> 0.1.1
• timescaledb 2.17.2 -> 2.18.1
• supautils 2.5.0 -> 2.6.0
• VectorChord 0.1.0 -> 0.2.0
• pg_bulkload 3.1.22 (+pg17)
• pg_store_plan 1.8 (+pg17)
• pg_search 0.14 -> 0.15.1
• pg_analytics 0.3.0 -> 0.3.2
• pgroonga 3.2.5 -> 4.0.0
• zhparser 2.2 -> 2.3
• pg_vectorize 0.20.0 -> 0.21.1

2025-01-10

• Add 10 el extensions
• rename pg_timescaledb to timescaledb-tsl on el distros
• pg_documentdb_core, and ferretdb
• VectorChord-bm25 (vchord_bm25) 0.1.0
• pg_tracing 0.1.2
• pg_curl 2.4
• pgxicor 0.1.0
• pgsparql 1.0
• pgjq 0.1.0
• hashtypes 0.1.5
• db_migrator 1.0.0
• pg_cooldown 0.1

2025-01-09

• lower_quantile 1.0.3
• quantile 1.1.8
• sequential_uuids 1.0.3
• pgmq 1.5.0 (subdir)
• floatvec 1.1.1
• rename postgresql-$v-timescaledb to postgresql-$v-timescaledb-tsl

New extensions:

• add omnisketch 1.0.2
• add ddsketch 1.0.1
• add pg_duration 1.0.1
• add ddl_historization 0.0.7
• add data_historization 1.1.0
• add schedoc 0.0.1
• add floatfile 1.3.1 https://pgxn.org/dist/floatfile/1.3.1/
• add pg_upless https://pgxn.org/dist/pg_upless/0.0.3/
• add pg_task 1.0.0
• add pg_readme 0.7.0
• add vasco 0.1.0
• add pg_xxhash 0.0.1

2025-01-08

• pg_anon 2.0.0
• pg_parquet 0.2.0
• wrappers 0.4.4
• pg_later 0.3.0
• topn fix for deb.arm64
• add age 17 on debian
• powa + pg17, 5.0.1
• h3 + pg17
• ogr_fdw + pg17
• age + pg17 1.5 on debian
• rdkit + pg17 on u24 (TBD)
• pgtap + pg17 1.3.3
• repmgr
• topn + pg17
• add synchdb for ubuntu (TBD)

2025-01-07

• pg_partman 5.2.4
• credcheck 3.0
• ogr_fdw 1.1.5
• ddlx 0.29
• postgis 3.5.1
• tdigest 1.4.3
• pg_repack 1.5.2

2024-12-30

• Build citus on all deb distros (amd/arm)
• Build pgroonga on all deb distros (amd/arm)
• Build timescaledb on all deb distros (amd/arm)
• Add synchdb v1.0 for pg16 on ubuntu distros ()

2024-12-24

• Build citus for el aarch64 distros

2024-12-23

• Add pig 0.0.1, the Pigsty CLI tool

2024-12-21

• Build pg_timescaledb for EL distros
• Build pgroonga for all distros