PGMQ

lastmod 2026-04-20created 2024-05-206 edits

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

A Postgres-based alternative to SQS

Features

• Open source implementation of a lightweight message queue, similar to AWS SQS and RSMQ, on top of Postgres
• Built purely as a Postgres extension, with no background workers or external dependencies
• Guarantees 'exactly once' message delivery to a consumer within a visibility timeout
• Messages remain in the queue until explicitly removed
• Messages can be archived instead of deleted, for long-term retention and replay
• API-compatible with AWS SQS and RSMQ

Keeping Postgres queues healthy

See PostgreSQL:Queue#Keeping Postgres queues healthy for details.

See also

• Postgres
• Supabase:Queues
• SQS

Favorite site

• Github - tembo-io/pgmq
• Github - pgmq/pgmq
• Supabase Queues | Supabase Docs (Supabase Queues)
• Switching our in-house message queue stack: Kafka → PGMQ (PostgreSQL Message Queue) - 67% reduction in payload data size
• Using PGMQ for transactional messages
• Keeping a single transaction, and PGMQ
• For transactional messaging, too, just use PostgreSQL | Yozm IT