Roadmap

Extension Rodapmap, on our radar, backlogs, defects, changes, and retired list.

1: Todo List
2: Bad Case
3: Changelog

1 - Todo List

Which extensions are coming next? and which are not planned?

Resource

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 - Bad Case

Not all extensions are perfect, some have defects, some are not yet supported, here are the noted bad cases.

Bad Case

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 will invalidate duckdb_fdw
documentdb is not available on arm arch

PG17 Support

The following extensions are not yet supported on PostgreSQL 17:

age: Ubuntu 24 has partial support
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

Lack of License

jsonb_apply 0.1.0

Missing RPM

These extensions are EL system-specific and need to be ported to Debian systems:

mobilitydb
rdkit
hstore_pllua
hstore_plluau
debversion
pg_rrule

Missing DEB

These extensions are Debian system-specific and need to be ported to EL systems:

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 - Changelog

Pigsty extension repository changelog

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