postgresql-is-awesome
github.com/oskardudycz/postgresql-is-awesome ↗Resources I found during my journey with PostgreSQL.
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me logical replication resources from postgresql-is-awesome"
Installation instructions →What's inside
Queuing
- Adriano Caloiaro - Choose Postgres queue technology
Choose Postgres queue technology
- pg-boss - Queueing jobs in Node.js using PostgreSQL like a boss
Queueing jobs in Node.js using PostgreSQL like a boss
Locks
- Alvaro Herrera - Postgres - Waiting for 9.5 – Implement SKIP LOCKED for row-level locks
Postgres - Waiting for 9.5 – Implement SKIP LOCKED for row-level locks
- Chris Hanks - Turning PostgreSQL into a queue serving 10,000 jobs per second
Turning PostgreSQL into a queue serving 10,000 jobs per second
- Marco Slot - PostgreSQL rocks, except when it blocks: Understanding locks
PostgreSQL rocks, except when it blocks: Understanding locks
- Marco Slot - When Postgres blocks: 7 tips for dealing with locks
When Postgres blocks: 7 tips for dealing with locks
- Nickolay Ihalainen - PostgreSQL locking, Part 1: Row Locks
PostgreSQL locking, Part 1: Row Locks
- Nickolay Ihalainen - PostgreSQL locking, part 2: heavyweight locks
PostgreSQL locking, part 2: heavyweight locks
Partitioning
- Amit Jain - How to Take Advantage of the New Partitioning Features in PostgreSQL 11
How to Take Advantage of the New Partitioning Features in PostgreSQL 11
- Automatically Creating Partition in PostgreSQL
- AWS - Managing PostgreSQL partitions with the pg_partman extension
Managing PostgreSQL partitions with the pg_partman extension
- AWS - Partition existing tables using native commands in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL
Partition existing tables using native commands in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL
- Azure - Azure Database for PostgreSQL : Logical Replication
Azure Database for PostgreSQL : Logical Replication
- Daniel Westermann - PostgreSQL 14: Automatic hash and list partitioning?
PostgreSQL 14: Automatic hash and list partitioning?
WAL
- Amit Kapila - Replication Improvements In PostgreSQL-14Logical Replication
Replication Improvements In PostgreSQL-14
- AWS Database Blog - Stream changes from Amazon RDS for PostgreSQL using Amazon Kinesis Data Streams and AWS LambdaLogical Replication
Stream changes from Amazon RDS for PostgreSQL using Amazon Kinesis Data Streams and AWS Lambda
- AWS - Using logical replication to replicate managed Amazon RDS for PostgreSQL and Amazon Aurora to self-managed PostgreSQLLogical Replication
Using logical replication to replicate managed Amazon RDS for PostgreSQL and Amazon Aurora to self-managed PostgreSQL
- Azure Database for PostgreSQL—Logical decoding and wal2json for change data captureLogical Replication
- Devrim Gündüz -WAL: Everything you want to know
- Fujistsu - How PostgreSQL 15 improved communication in logical replicationLogical Replication
How PostgreSQL 15 improved communication in logical replication
Postgres-based databases
- Apache AGE - Postgres extension - Graph database optimized for fast analysis and real-time data processing
Postgres extension - Graph database optimized for fast analysis and real-time data processing
- Citus - Distributed PostgreSQL as an extension
Distributed PostgreSQL as an extension
- Google - Run AlloyDB anywhere - in your data center, your laptop, or in any cloud
Run AlloyDB anywhere - in your data center, your laptop, or in any cloud
- Neon
- Supabase - Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage
Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage
Scaling
- Cloudflare - Performance isolation in a multi-tenant database environment
Performance isolation in a multi-tenant database environment
Wire Protocol
- DataStation - The world of PostgreSQL wire compatibility
The world of PostgreSQL wire compatibility
Hosting
- ElephantSql
- Fly.io - Postgres
Postgres
Showing a sample of 62 resources. View the full list on GitHub →