select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_plan_advice · Describe and constrain planner choices with plan advice · Features · PostgreSQL · C · Not packagedpgmq · A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. · 1.13.0 · Features · PostgreSQL · SQL · Packagedpg_durable · SQL-native durable orchestrations for PostgreSQL · 0.2.8 · Features · PostgreSQL · Rust · Packagedindex_advisor · Query index advisor · 0.2.0 · Features · PostgreSQL · SQL · Packagedhypopg · Hypothetical indexes for PostgreSQL · 1.4.3 · Features · PostgreSQL · C · Packagedpg_ivm · incremental view maintenance on PostgreSQL · 1.15 · Features · PostgreSQL · C · Packagedrum · RUM index access method · 1.3.15 · Features · PostgreSQL · C · Packagedjsquery · data type for jsonb inspection · 1.2 · Features · PostgreSQL · C · Packagedpostgres-json-schema · Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. · 0.1.1 · Features · PostgreSQL · SQL · Not packagedimgsmlr · Image similarity with haar · 1.0 · Features · PostgreSQL · C · Packagedpg_incremental · Incremental Processing by Crunchy Data · 1.5.0 · Features · PostgreSQL · C · Packagedplan_filter · filter statements by their execution plans. · 0.0.1 · Features · PostgreSQL · C · Packagedpg_idx_advisor · PostgreSQL index advisor · 0.1.2 · Features · PostgreSQL · C · Not packagedlsm3 · LSM tree index access method based on PostgreSQL B-tree indexes · 1.0 · Features · PostgreSQL · C · Not packagedpg_ttl_index · Automatic data expiration with TTL indexes · 3.0.0 · Features · PostgreSQL · C · Packagedpg_shared_plans · Proof-of-concept shared-memory execution-plan cache for PostgreSQL · 0.0.1 · Features · PostgreSQL · C · Not packagedpg_message_queue · Listen/Notify-based PostgreSQL message queue extension · 0.2.1 · Features · PostgreSQL · SQL · Not packagedpg_doc_store · Provides a JSONB document-store API with full-text search. · 0.2.1 · Features · PostgreSQL · SQL · Not packagedpg_variables · Session-scoped variables with scalar, array, and record types · 1.2.5 · Features · PostgreSQL · C · Packagedjson_schema_validate · Validate JSON and JSONB data against JSON Schema in PostgreSQL · 0.1.0 · Features · PostgreSQL · C · Not packagedsaio · Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO · 0.0.1 · Features · PostgreSQL · C · Not packagedpg_disorder · Perturb unordered SELECT row order to expose order-dependent tests · 0.1.0 · Features · PostgreSQL · C · Packagedpg_dropbuffers · Drop PostgreSQL shared buffers and the operating-system page cache for testing · 0.0.1 · Features · PostgreSQL · C · Not packagedmemoryam · In-memory TableAM implementation · 0.0.1 · Features · PostgreSQL · C · Not packagedpg_ladybug · Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine. · 1.0 · Features · PostgreSQL · C · Not packagedpgmb · A simple PostgreSQL Message Broker system · 1.0.0 · Features · PostgreSQL · SQL · Packagedqgres · Simple queue system · 0.1.2 · Features · PostgreSQL · SQL · Not packagedsession_variables · SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. · 0.0.4 · Features · PostgreSQL · SQL · Not packagedmy_extension · A Basic PostgreSQL Extension · 1.1.0 · Features · PostgreSQL · SQL · Not packagedpg_thud · Framework extending pgtap with scaffolding and test-data helpers for database unit tests. · 0.1.0 · Features · PostgreSQL · SQL · Not packagedpg_xclaim · High-cardinality transaction-scoped logical claim primitive for PostgreSQL · 1.0.0-rc1 · Features · PostgreSQL · C · Not packagedwiki · In-database wiki data model and SQL/PLPerl API with optional MediaWiki integration. · 0.1 · Features · PostgreSQL · SQL · Not packagedpg_git · Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. · 0.4.0 · Features · PostgreSQL · SQL · Not packagedpg_synthesize_wal · Generate PostgreSQL WAL records of various sizes · 1.0 · Features · PostgreSQL · C · Not packagedbloom · bloom access method - signature file based index · 1.0 · Features · PostgreSQL · C · Packagedevent_manager · Loosely coupled PostgreSQL event trigger and queue system with synchronous or asynchronous processing. · 0.1 · Features · PostgreSQL · C · Not packagedjson_enhancements_no_hstore · Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2 · 1.0.0 · Features · PostgreSQL · C · Not packagedjson_enhancements_with_hstore · Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2 · 1.0.0 · Features · PostgreSQL · C · Not packagedpg_reactive · Live SQL query subscriptions with result deltas over LISTEN/NOTIFY · 0.1.8 · Features · PostgreSQL · C · Not packagedpgwaffles · A postgres extension to display the best waffles recipe · 1.0.1 · Features · PostgreSQL · C · Not packaged

40 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_plan_advice Describe and constrain planner choices with plan advice FEAT PostgreSQL C 19 22k
pgmq 1.13.0 A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. FEAT PostgreSQL SQL 14–18 5.1k
pg_durable 0.2.8 SQL-native durable orchestrations for PostgreSQL FEAT PostgreSQL Rust 17–18 2.8k
index_advisor 0.2.0 Query index advisor FEAT PostgreSQL SQL 14–18 1.7k
hypopg 1.4.3 Hypothetical indexes for PostgreSQL FEAT PostgreSQL C 14–18 1.7k
pg_ivm 1.15 incremental view maintenance on PostgreSQL FEAT PostgreSQL C 14–18 1.5k
rum 1.3.15 RUM index access method FEAT PostgreSQL C 14–18 840
jsquery 1.2 data type for jsonb inspection FEAT PostgreSQL C 14–18 710
postgres-json-schema 0.1.1 Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints. FEAT PostgreSQL SQL 508
imgsmlr 1.0 Image similarity with haar FEAT PostgreSQL C 14–18 264
pg_incremental 1.5.0 Incremental Processing by Crunchy Data FEAT PostgreSQL C 16–18 228
plan_filter 0.0.1 filter statements by their execution plans. FEAT PostgreSQL C 14–18 96
pg_idx_advisor 0.1.2 PostgreSQL index advisor FEAT PostgreSQL C 10–18 51
lsm3 1.0 LSM tree index access method based on PostgreSQL B-tree indexes FEAT PostgreSQL C 31
pg_ttl_index 3.0.0 Automatic data expiration with TTL indexes FEAT PostgreSQL C 15–18 24
pg_shared_plans 0.0.1 Proof-of-concept shared-memory execution-plan cache for PostgreSQL FEAT PostgreSQL C 12–17 22
pg_message_queue 0.2.1 Listen/Notify-based PostgreSQL message queue extension FEAT PostgreSQL SQL 10–18 21
pg_doc_store 0.2.1 Provides a JSONB document-store API with full-text search. FEAT PostgreSQL SQL 10–18 15
pg_variables 1.2.5 Session-scoped variables with scalar, array, and record types FEAT PostgreSQL C 14–18 13
json_schema_validate 0.1.0 Validate JSON and JSONB data against JSON Schema in PostgreSQL FEAT PostgreSQL C 14–18 12
saio 0.0.1 Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO FEAT PostgreSQL C 10
pg_disorder 0.1.0 Perturb unordered SELECT row order to expose order-dependent tests FEAT PostgreSQL C 14–18 6
pg_dropbuffers 0.0.1 Drop PostgreSQL shared buffers and the operating-system page cache for testing FEAT PostgreSQL C 6
memoryam 0.0.1 In-memory TableAM implementation FEAT PostgreSQL C 5
pg_ladybug 1.0 Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine. FEAT PostgreSQL C 17–18 5
pgmb 1.0.0 A simple PostgreSQL Message Broker system FEAT PostgreSQL SQL 14–18 3
qgres 0.1.2 Simple queue system FEAT PostgreSQL SQL 3
session_variables 0.0.4 SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. FEAT PostgreSQL SQL 10–18 3
my_extension 1.1.0 A Basic PostgreSQL Extension FEAT PostgreSQL SQL 2
pg_thud 0.1.0 Framework extending pgtap with scaffolding and test-data helpers for database unit tests. FEAT PostgreSQL SQL 10–18 2
pg_xclaim 1.0.0-rc1 High-cardinality transaction-scoped logical claim primitive for PostgreSQL FEAT PostgreSQL C 2
wiki 0.1 In-database wiki data model and SQL/PLPerl API with optional MediaWiki integration. FEAT PostgreSQL SQL 10–12 2
pg_git 0.4.0 Implements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions. FEAT PostgreSQL SQL 12–18 1
pg_synthesize_wal 1.0 Generate PostgreSQL WAL records of various sizes FEAT PostgreSQL C 15–18 1
bloom 1.0 bloom access method - signature file based index FEAT PostgreSQL C 14–18
event_manager 0.1 Loosely coupled PostgreSQL event trigger and queue system with synchronous or asynchronous processing. FEAT PostgreSQL C 10–18
json_enhancements_no_hstore 1.0.0 Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2 FEAT PostgreSQL C
json_enhancements_with_hstore 1.0.0 Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2 FEAT PostgreSQL C
pg_reactive 0.1.8 Live SQL query subscriptions with result deltas over LISTEN/NOTIFY FEAT PostgreSQL C 15–18
pgwaffles 1.0.1 A postgres extension to display the best waffles recipe FEAT PostgreSQL C