PostgreSQL cheatsheet (advance)

• cstore_fdw - Columnar store for analytics with PostgreSQL.

• cyanaudit - Cyan Audit provides in-database logging of all DML activity on a column-by-column basis.

• pg_cron - Run periodic jobs in PostgreSQL.

• pglogical - Extension that provides logical streaming replication.

• pg_partman - Partition management extension for PostgreSQL.

• pg_paxos - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes.

• pg_shard - Extension to scale out real-time reads and writes.

• PGStrom - Extension to offload CPU-intensive workloads to GPU.

• pgxn PostgreSQL Extension Network - central distribution point for many open-source PostgreSQL extensions

• PipelineDB - A PostgreSQL extension that runs SQL queries continuously on streams, incrementally storing results in tables.

• plpgsql_check - Extension that allows to check plpgsql source code.

• PostGIS - Spatial and Geographic objects for PostgreSQL.

• PG_Themis - Postgres binding as an extension for crypto library Themis, providing various security services on PgSQL's side.

• zomboDB - Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch.

• pgMemento - Provides an audit trail for your data inside a PostgreSQL database using triggers and server-side functions written in PL/pgSQL.

• timescaleDB - Open-source time-series database fully compatible with Postgres, distributed as an extension

• pgTAP - Database testing framework for Postgres