pgrx Rust PostgreSQL extensions

Top 5 Best PostgreSQL Background Worker Patterns for Safe Shared Memory Use

Cary Huang
March 3, 2026March 3, 2026
postgresql

Introduction: Why PostgreSQL Background Workers Deserve a Playbook Once I started pushing PostgreSQL background workers beyond simple demos, I realized they behave like first-class citizens in the server, with all the same responsibilities and risks. A worker crash, a deadlock… Read More »Top 5 Best PostgreSQL Background Worker Patterns for Safe Shared Memory Use

Mastering Memory Contexts in Rust pgrx PostgreSQL Extensions

Cary Huang
January 31, 2026January 31, 2026
Rust Programming

Introduction: Why Memory Contexts Matter for Rust pgrx Extensions When I started writing my first Rust pgrx PostgreSQL extension, I assumed Rust’s ownership model would “just” keep me safe. Then I hit my first crash caused by PostgreSQL freeing memory… Read More »Mastering Memory Contexts in Rust pgrx PostgreSQL Extensions