Extension List
The complete 336 PostgreSQL Extension List available in Pigsty
Extension: PGSQL
There are 336 PostgreSQL extensions available in Pigsty, with out-of-box RPM/DEB packages"
Module:
There are 336 PostgreSQL extensions available in Pigsty, including 326 RPM extensions available in EL and 312 DEB extensions available in Debian/Ubuntu.
There are 70 PostgreSQL built-in Contrib extensions, alone with (109+133) deb and (135+121) rpm extensions provided by PGDG and Pigsty.
We have an extension catalog and usage instructions. Even if you are not using Pigsty, you can still use our extension repository.
Use Extension
How to install, load, create, update, remove PostgreSQL extensions in Pigsty?
Build & Packaging
Prepare PostgreSQL rpm/deb pacakge building environment, and some packaging hints
Category: TIME
TIME: TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
Category: GIS
GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
Category: RAG
RAG: Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
Category: FTS
FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
Category: OLAP
OLAP: DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
Category: FEAT
FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
Category: LANG
LANG: Develop, Test, Package, and Deliver Stored Procedures written in various PL/Lanaguages: Java, Js, Lua, R, Sh, PRQL, …
Category: TYPE
TYPE: Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
Category: FUNC
FUNC: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…
Category: ADMIN
ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
Category: STAT
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
Category: SEC
SEC: Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Erros, Extension White List, …
Category: FDW
FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
Category: SIM
SIM: Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
Category: ETL
ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.