Richard Yen

On October 1, I’ll be speaking at PG Summit 2026 about benchmarking hardware with Postgres.

Did you know: PG19 is on track to contain the most changes to pg_catalog in history Introduction pg_catalog is one of the most important interfaces PostgreSQL gives us: it exposes the metadata that describes database structure – tables, columns, indexes,…

A practical guide to what .ready and .done mean, and why WAL sticks around Introduction It is 9:12 a.m. on a Monday.

Picking Up Where We Left Off In the previous post, I tried to lay out the framing half of this material: what actually counts as a disaster, why preparation and prevention aren’t the same as recovery, and how RPO and RTO end up being conversations with le…

Introduction I recently had the privilege of speaking at POSETTE 2026 about pg_stats and how Postgres internal statistics work (YouTube Recording).

The Landscape Has Changed When I was at Turnitin, we were still kind of riding the tail end of the dot-com boom.

Introduction PGDay Boston 2026 was a rewarding reminder of why I value the PostgreSQL community so much.

Introduction I recently wrote a post about WAL log shipping and how a standby built on log shipping is a great way to give data analysts production data without putting the primary at risk.

Introduction If you’ve been running PostgreSQL for any length of time, you’ve probably heard about transaction ID (XID) wraparound.

Introduction Over the past year, I’ve worked in a handful of contexts managing large volumes of data stored as JSONB in PostgreSQL.

This post was originally published on the Microsoft Tech Community Blog.