The notifier pattern for applications that use Postgres(brandur.org)

173 points by kiyanwang 2 years ago | 41 comments

Postgres UUIDv7 and per-back end monotonicity(brandur.org)

215 points by craigkerstiens 1 year ago | 97 comments

Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go(brandur.org)

52 points by gmcabrita 2 years ago | 39 comments

Does anyone run Postgres without PgBouncer?(brandur.org)

137 points by abelanger 2 months ago | 89 comments

The minimum viable unit of saleable software(brandur.org)

185 points by brandur 4 months ago | 64 comments

Postgres as queue(leontrolski.github.io)

178 points by leontrolski 2 years ago | 93 comments

Choose Postgres queue technology(adriano.fyi)

680 points by bo0tzz 3 years ago | 321 comments

Blog post by Adriano Caloiaro arguing for using Postgres-based queue technology for background jobs instead of dedicated queue systems.

Show HN: PgQueuer – Transform PostgreSQL into a Job Queue(github.com)

350 points by jeeybee 2 years ago | 110 comments

GitHub repository for PgQueuer, a Python library that uses PostgreSQL and LISTEN/NOTIFY to implement an efficient job queue.

SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue(prequel.co)

557 points by ctc24 3 years ago | 319 comments

Prequel blog post explaining why the company replaced RabbitMQ with a PostgreSQL-based job queue.

PostgreSQL for Everything(raphaelbauer.com)

412 points by karlmush 2 months ago | 238 comments

A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.

Making Postgres slower(byteofdev.com)

320 points by AsyncBanana 1 year ago | 35 comments

A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.

Postgres with QUIC(blogs.lupyd.com)

10 points by tenesripranav 26 days ago | 0 comments

A Lupyd blog post arguing that QUIC stream multiplexing beats traditional TCP connection pooling for Postgres over WAN, with benchmark numbers.