Category: TIME
TIME: TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
TIME: TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
RAG: Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
OLAP: DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
LANG: Develop, Test, Package, and Deliver Stored Procedures written in various PL/Lanaguages: Java, Js, Lua, R, Sh, PRQL, …
TYPE: Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
FUNC: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…
ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
List of PostgreSQL extensions supported by Pigsty, and their compatibility on different OS distros.
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
SEC: Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Erros, Extension White List, …
FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
SIM: Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
Enables scalable inserts and complex queries for time-series data (Apache 2 Edition)
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal tables
E-Maj extension enables fine-grained write logging and time travel on subsets of the database.
PostgreSQL table versioning extension
Job scheduler for PostgreSQL
pg_later: Run queries now and get results later
Run SQL queries in the background
Advanced scheduling for PostgreSQL
PostGIS geometry and geography spatial types and functions
pgRouting Extension
data type for lidar point clouds
H3 bindings for PostgreSQL
q3c sky indexing plugin
foreign-data wrapper for GIS data access
IP-based geolocation query
Handle geohash based functionality for spatial coordinates
MobilityDB geospatial trajectory data management & analysis platform
calculate great-circle distances on the surface of the Earth
vector data type and ivfflat and hnsw access methods
pgvectorscale: Advanced indexing for vector data
The simplest way to do vector search on Postgres
support similarity queries
Effective similarity search
pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
PostgresML: Run AL/ML workloads with SQL interface
pg_search: Full text search for PostgreSQL using BM25
create 2-gram (bigram) index for faster full text search.
a parser for full-text search of Chinese
Czech Hunspell Dictionary
German Hunspell Dictionary
en_US Hunspell Dictionary
French Hunspell Dictionary
Nepali Hunspell Dictionary
Dutch Hunspell Dictionary
Norwegian (norsk) Hunspell Dictionary
Portuguese Hunspell Dictionary
Russian Hunspell Dictionary
Russian Hunspell Dictionary (from AOT.ru group)
determine similarities and distance between strings
text similarity measurement and index searching based on trigrams
Distributed PostgreSQL as an extension
Hydra Columnar extension
Postgres for analytics, powered by DuckDB
pg_lakehouse: An analytical query engine for Postgres
DuckDB Embedded in Postgres
DuckDB Foreign Data Wrapper
foreign-data wrapper for parquet on S3
Table partitioning by foreign key utility
Extension to manage partitioned tables by time or ID
Database partitioning implemented as procedural language
PG-Strom - big-data processing acceleration using GPU and NVME
functions that manipulate whole tables, including crosstab
AGE graph database extension
type for storing hyperloglog data
RUM index access method
pg_graphql: GraphQL support
PostgreSQL extension providing JSON Schema validation
data type for jsonb inspection
Give PostgreSQL ability to manually force some decisions in execution plans.
Hypothetical indexes for PostgreSQL
Query index advisor
Image similarity with haar
incremental view maintenance on PostgreSQL
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Generic queue for PostgreSQL
Cheminformatics functionality for PostgreSQL.
bloom access method - signature file based index
Trusted Language Extensions for PostgreSQL
PL/JavaScript (v8) trusted procedural language
Lua as an untrusted procedural language
Use PRQL in PostgreSQL - Pipelined Relational Query Language
server-side support for debugging PL/pgSQL functions
extended check for plpgsql functions
server-side support for profiling PL/pgSQL functions
PL/sh procedural language
PL/Java procedural language (https://tada.github.io/pljava/)
load R interpreter and execute R script from within a database
Unit testing for PostgreSQL
Wrapper for the Faker Python library
OSDL-DBT-2 test kit
PL/Tcl procedural language
PL/Perl procedural language
PL/PerlU untrusted procedural language
PL/pgSQL procedural language
PL/Python3U untrusted procedural language
Prefix Range module for PostgreSQL
Semantic version data type
SI units extension
type for storing 128-bit binary data inline
asn1oid extension
support for Roaring Bitmaps
fast faceting queries using an inverted index
spherical objects with useful functions, operators and index support
Country data type, ISO 3166-1
Custom PostgreSQL currency type in 1Byte
Multiple Precision Arithmetic extension
numeral datatypes extension
bigint fractions
unsigned integer types
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
URI Data type for PostgreSQL
Email address type for PostgreSQL
ACL Data type
Debian version number data type
RRULE field type for PostgreSQL
timestamp nanosecond resolution
data type for auto-encrypted passwords
data types for international product numbering standards
data type for representing line segments or floating-point intervals
data type for multidimensional cubes
data type for hierarchical tree-like structures
data type for storing sets of (key, value) pairs
data type for case-insensitive character strings
XPath querying and XSLT
type for top-n JSONB
gzip and gunzip functions.
Zstandard compression algorithm implementation in PostgreSQL
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Async HTTP Requests
PostgreSQL email validation that is consistent with the HTML5 spec
Some functions and views for daily usage
Some date time functions and operators that,
High-accuracy timing of SQL expressions
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
Extra Window Functions for PostgreSQL
first() and last() aggregate functions
Provides tdigest aggregate function.
Aggregate functions for array inputs
Various functions for computing statistics on arrays of numbers
Array math and operators that work element by element on the contents of arrays
Quantile aggregation function
Lower quantile aggregate function
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7: create UUIDv7 values in postgres
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Short unique id generator for PostgreSQL, using hashids
generator of sequential UUIDs
GSL statistical functions for postgresql
random data generator
Integer Base36 types
Base62 extension for PostgreSQL
Math for vectors (arrays) of numbers
Financial aggregate functions
JSON Web Token API for Postgresql
Stable hash functions for Postgres
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
Encryption functions for int and bigint values
uECC bindings for Postgres
Perl Compatible Regular Expression functions
Access ICU functions
QR Code generator from PostgreSQL
Fetch the value of an environment variable
Protobuf support for PostgreSQL
url_encode, url_decode functions
functions for implementing referential integrity (obsolete)
functions for autoincrementing fields
functions for tracking who changed a table
functions for tracking last modification time
TABLESAMPLE method which accepts time in milliseconds as a limit
text search dictionary template for extended synonym processing
TABLESAMPLE method which accepts number of rows as a limit
Triggered change notifications
generate universally unique identifiers (UUIDs)
support for indexing common datatypes in GiST
support for indexing common datatypes in GIN
functions, operators, and index support for 1-D arrays of integers
integer aggregator and enumerator (obsolete)
text search dictionary template for integers
text search dictionary that removes accents
get and set the priority of PostgreSQL backends
Reorganize tables in PostgreSQL databases with minimal locks
A tool to remove unused space from a relation.
Read dead but unvacuumed rows from table
examine and manage the os buffer cache
An in-database data dictionary providing database introspection via standard SQL query syntax. Developed using pgx (https://github.com/zombodb/pgx).
DDL eXtractor functions
get and set the priority of PostgreSQL backends
Activate/deactivate/verify checksums in offline Postgres clusters
cluster database read only
PostgreSQL extension to access the OS process table
Require criteria for UPDATE and DELETE
view object permissions and compare them with the desired state
pg_auto_failover
Diagnosing system catalog corruption
Pre Prepare your Statement server side
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
Deal with orphaned files
Send random signals to random processes
Provides cheat (but useful) functions
Postgres extension to save OOPS mistakes
record table modification logs and PITR for table/row
PostgreSQL File I/O Functions
Administrative functions for pgPool
A PostgreSQL job scheduler
utility program that will remove any orphaned large objects from a PostgreSQL database
prewarm relation data
utility program that helps administrators to examine the file structure used by PostgreSQL
Large Object maintenance
an example of an archive module
adds a custom basebackup target called shell
utilities in support of old_snapshot_threshold
administrative functions for PostgreSQL
functions for verifying relation integrity
extension to perform surgery on a damaged relation
PostgreSQL load profile repository and report builder
show query plans of all currently running SQL statements
Kernel statistics gathering
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
An extension collecting statistics about quals
track plan statistics of all SQL statements executed
Track settings changes
sampling based statistics of wait events
EnterpriseDB system statistics for PostgreSQL
Normalized, friendlier system catalog for PostgreSQL
Capture node OS metrics via SQL queries
Provide SQL interface to logs
Small PostgreSQL background worker to report whether a node is a replication master or standby
show memory usage
record table modification logs
show details on toasted datums
PostgreSQL extension to enhance query monitoring
stats visualization and time series analysis
pgexporter extension for extra metrics
Monitor PostgreSQL processes similar to unix top
Visualise database pages in ascii code
PostgreSQL Workload Analyser-core
inspect the contents of database pages at a low level
show row-level locking information
information about SSL certificates
examine the shared buffer cache
functions to inspect contents of PostgreSQL Write-Ahead Log
examine the free space map (FSM)
examine the visibility map (VM) and page-level visibility info
show tuple-level statistics
Provides a means for logging execution plans of slow statements automatically
track planning and execution statistics of all SQL statements executed
Strengthen PostgreSQL user password checks with cracklib
Extension that secures a cluster on a cloud environment
Postgres extension for libsodium functions
Supabase Vault Extension
Data anonymization tools
pg_tde access method
PostgreSQL SM Algorithm Extension
provides auditing functionality
pgAudit addon to redirect audit log to an independent file
monitor connection attempts per user
credcheck - postgresql plain text credential checker
cryptographic key management
Extension for logging and monitoring functions in PostgreSQL
Function for collecting statistics about messages in logfile
login_hook - hook to execute login_hook.login() at login time
similar to SET ROLE but with added logging
The PostgreSQL Antivirus
PostgreSQL Extension Whitelisting
Audit data changes and provide flashback ability
A Postgres extension for managing SSL certificates through SQL
Module for blocking SET variables for non-super users.
label-based mandatory access control (MAC) based on SELinux security policy.
pause briefly before reporting authentication failure
cryptographic functions
MySQL compatibility functions
Foreign data wrappers developed by Supabase
Fetch foreign data in Python in your PostgreSQL server.
Foreign data wrapper for accessing remote databases using ODBC
foreign-data wrapper for remote servers available over JDBC
Foreign data wrapper for querying a MySQL server
foreign data wrapper for Oracle access
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
foreign data wrapper for DB2 access
SQLite Foreign Data Wrapper
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
foreign data wrapper for MongoDB access
Foreign data wrapper for querying a Redis server
Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka Foreign Data Wrapper for CSV formated messages
foreign-data wrapper for remote hdfs servers
Foreign data wrapper for Firebird
aws_s3 postgres extension to import/export data from/to s3
foreign-data wrapper for Postgres log file access
connect to other PostgreSQL databases from within a database
foreign-data wrapper for flat file access
foreign-data wrapper for remote PostgreSQL servers
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Extension to add Global Temporary Tables feature to PostgreSQL
Registration and manipulation of session variables and constants
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
SQL Server Transact SQL Datatype Support
SQL Server Transact SQL compatibility
SQL Server TDS protocol extension
SQL Server Money Data Type
memcached interface
PostgreSQL Logical Replication
automated ddl deployment using pglogical
PG Failover Slots extension
Changing data capture in JSON format
PostgreSQL logical decoding output plugin for MongoDB
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Output plugin for logical replication in Raw SQL format
SQL-based test/example module for WAL logical decoding
Extension for specialized, per-table replication between PostgreSQL instances
Replication manager for PostgreSQL
Copy a Postgres database to a target Postgres server
Migrate to PostgreSQL in a single command!
build fact tables with Postgres
pg_bulkload is a high speed data loading utility for PostgreSQL
Comparation of testing and production services PostgreSQL databases.
command line utility for importing XML, JSON, BYTEA document to PostgreSQL
export XML, JSON and BYTEA documents from PostgreSQL