HOW2025-让你的扩展对世界可见.pdf

1、Pigsty让你的扩展对世界可见 PG 生态缺失的包管理器与扩展仓库Ruohang Feng Author of PIGSTY https:/pigsty.io/ext/pig Extension Day2025-05-12 MontrealIPGSTYPigstyAbout MeIPGSTYRuohang Feng,Author&Founder PigstyFounder Pigsty Architect Apple DBA TanTan Developer AlibabaEmail: Github:https:/ Twitter:https:/ LinkedIn:https:/ Exten

2、sion Out-of the boxGotta Catch Them All!PigstyOutlineWhy What How Next为什么我们需要仓库与包管理器？当前的现状与解决方案 挑战与经验教训 下一步将会是什么？PigstyWHYPostgreSQL 正在吞噬 整个数据库世界 通过扩展PGVECTORzhparserpgroongaFDWFull Text SearchGeo SpatialOLAPGISWaterDuckDB FDWS3pg_timeseriespgvector scalepg_vectorizepg_tiktokenH3AI ML RAGpg_parquetp

3、g_trgmpg_similarityPGQpgmqFeaturedpg_ivmjsqueryTime TemporalimgsmlrHLLRUMpgttgzip zstd pgpdfhttppg_netpg_tdepg_hint_plantemporal_tablestable_versionperiodshunspellsmlarpgaipg_summarizeplan_filterpg_geohashpgqrcardanopg_polylinee-majPG4MLVectorChordpg_bigmpg_bm25anonpglitefusionpg_mooncakeHYDRASTORMD

4、ocumentDBjsonschemapgragPostgresMLpgpdfVectorChord-bm25pg_bestmatchPL/LanguagePL/shPL/V8PL/rustpgrxPL/HaskellSchemePL/Ruby PL/Python PL/PHPPL/LuaPL/goPL/RPL/prologPL/PRQLPL/PerlPL/SQLPL/TCLPL/PgSQLWhy would we need such a thing?PGXN 扩展数量375:1年前 422:今日 12.5%同比增长PigstyGISWaterH3pg_geohashpg_polylinepg

5、_timeseriestemporal_tablestable_versionperiodse-majPGVECTORpgvector scalepg_vectorizepg_tiktokenpg_similaritysmlarpgaipg_summarizePG4MLVectorChordpgragPostgresMLPGQpgmqpg_ivmjsqueryHLLRUMpgttgzip zstd bziphttppg_netpg_tdepg_hint_planplan_filterpgqrcardanoanonpglitefusionDocumentDBjsonschemapgpdfPL/s

6、hPL/V8PL/rustpgrxPL/HaskellSchemePL/Ruby PL/Python PL/PHPPL/LuaPL/goPL/RPL/prologPL/PRQLPL/PerlPL/SQLPL/TCLPL/PgSQLS3DuckDB FDWpg_parquetpg_mooncakeHYDRASTORMzhparserpgroongapg_trgmimgsmlrhunspellpg_bigmpg_bm25VectorChord-bm25pg_bestmatchPigstyPostgreSQL 正在成为 数据库世界的 Linux 内核KernelDistributionThe def