--- title: "PostgreSQL queues done right with PgQ | POSETTE: An Event for Postgres 2026" url: https://daily.dev/posts/postgresql-queues-done-right-with-pgq-posette-an-event-for-postgres-2026-wza8y552h source_url: https://www.youtube.com/watch?v=N5b0CayG5rg type: video:youtube source: "Microsoft Developer" published: 2026-06-17T12:11:42.140Z updated: 2026-06-17T12:12:13.896Z tags: ["architecture", "postgresql"] reading_time: 28 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL queues done right with PgQ | POSETTE: An Event for Postgres 2026 **[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 28 min read · 0 upvotes · 0 comments ## Summary PgQ is a PostgreSQL extension for implementing queues that has existed since 2007, and this talk explains why it outperforms the common SELECT FOR UPDATE SKIP LOCKED approach. The SKIP LOCKED pattern causes table bloat, dead tuples, excessive UPDATEs/DELETEs, and planner confusion. PgQ solves these problems using snapshot-based event handling, table inheritance with rotating child tables, batch processing, and a maintenance daemon (pgqd). The extension produces zero dead tuples and no write overhead on queue tables. For managed cloud Postgres services that don't natively support PgQ, it can be compiled as pure PL/pgSQL using 'make plonly', and pgqd's functionality can be replicated using pg_cron with custom wrapper procedures. The talk covers the full SQL API, internal architecture, and practical deployment strategies. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg\_cron to tick.](https://daily.dev/posts/github---nikolays-pgque-pgque-zero-bloat-postgres-queue-one-sql-file-to-install-pg-cron-to-tick-idiaxcm6k) · Hacker News · 80 upvotes · 3 comments --- Tags: [#architecture](https://daily.dev/tags/architecture), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/postgresql-queues-done-right-with-pgq-posette-an-event-for-postgres-2026-wza8y552h)