SPI in PostgreSQL

Introduction When I first needed to process a stream of small maintenance queries without blocking client traffic, I realized I had to go beyond plain SQL and triggers. That’s where a PostgreSQL background worker in C became the right tool:… Read More »Case Study: Building a PostgreSQL Background Worker in C for Async SPI Jobs