Skip to main content


Articles and Blog Posts


  • pg-mem - An in memory postgres DB instance for your unit tests.
  • pg_hint_plan - Controls execution plan with hinting phrases in comment of special form.
  • Patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes.

    Note to Citus users: Starting from 3.0 Patroni nicely integrates with the Citus database extension to Postgres. Please check the Citus support page in the Patroni documentation for more info about how to use Patroni high availability together with a Citus distributed cluster. Note to Kubernetes users: Patroni can run natively on top of Kubernetes. Take a look at the Kubernetes chapter of the Patroni documentation.

  • High Availability Postgres on - Postgres + Stolon for HA clusters as Fly apps.
  • pgmetrics - Collect and display information and stats from a running PostgreSQL server.
  • yandex/odyssey - Scalable PostgreSQL connection pooler.
  • jackc/pgx - PostgreSQL driver and toolkit for Go.
  • Reshape - An easy-to-use, zero-downtime schema migration tool for Postgres.
  • Hydra - The open source Snowflake alternative. OLAP Postgres. Query any database via Postgres.
  • OrioleDB - Building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems).
  • Vectorized Executor - Speeding up PostgreSQL through vectorized execution.
  • migra - Like diff but for PostgreSQL schemas.
  • pgcli - Postgres CLI with autocompletion and syntax highlighting.
  • WaterbugDB - Raft + Postgres parser + Postgres wire protocol + Boltdb + ? = Distributed PostgreSQL.
  • HypoPG - Hypothetical Indexes for PostgreSQL.
  • RUM - RUM access method - inverted index with additional information in posting lists.
  • pgvm - PostgreSQL Version Manager.
  • pgBackRest - Reliable PostgreSQL backup & restore.
  • repmgr - A lightweight replication manager for PostgreSQL.



  • Awesome Postgres - A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql.