Repository Index

Open-source vector similarity search for Postgres

• nearest-neighbor-search
• approximate-nearest-neighbor-search

Distributed PostgreSQL as an extension

• database
• citus
• multi-tenant
• postgresql

One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.

• sparse-vector
• hybrid-search
• bm25
• full-text-search

Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.

• postgresql
• graph-database
• analytics
• postgresql-extension

Run periodic jobs in PostgreSQL

• postgresql
• cron
• periodic-jobs
• scheduler

Partition management extension for PostgreSQL

• partitioning
• plpgsql
• pg-partition-manager
• background-worker

Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.

• postgresql
• compression
• columnar-store
• columnar-storage

Repository contains pgRouting library. Development branch is "develop", stable branch is "master"

• postgis
• postgresql-extension
• routing
• spatial-analysis

Postgres extension and service for automated failover and high-availability

• postgresql
• postgres
• postgresql-extension
• high-availability

PostgreSQL Unit Testing Suite

• pgtap
• pgsql
• psql
• tap

Query Performance Monitoring Tool for PostgreSQL

• distpg
• pg
• statistics-collector
• postgresql

Audit trail with schema versioning for PostgreSQL using transaction-based logging

• postgresql
• versioning
• audit-trail
• plpgsql

Bi-Directional Multi-Master Replication (BDR) for PostgreSQL, deprecated, please visit 2ndQuadrant website for latest BDR3

PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.

• pacemaker
• postgresql
• postgres
• resource-agent

Active Session History for PostgreSQL — wait event sampling with zero bloat (pg_cron + PGQ-style partition rotation)

Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/