← Back to Blog
Series · 2 parts

Postgres features you can reach for instead of more infrastructure

A short series on Postgres features that quietly replace pieces of your stack. Pub/Sub via LISTEN and NOTIFY, the bloom index for wide tables, and more.

EducationMay 4, 2026

You Don't Need Redis, Postgres Already Has Pub/Sub

Postgres includes a lightweight Pub/Sub mechanism through LISTEN and NOTIFY. In this post, you'll build a small real-time Pub/Sub app with Bun, pg, and Prisma Postgres.

Prisma PostgresMay 28, 2026

Bloom Filters in Postgres: The Index Type Most Developers Overlook

One bloom index can replace a stack of B-trees on wide tables with many filter combinations. A tour of the concept, the Postgres extension, and a benchmark you can run yourself.