pg_background: make Postgres do the long work (while your session stays light)
Summary
pg_background enables PostgreSQL to execute long-running SQL asynchronously in dedicated background workers, allowing client sessions to remain responsive. The article covers v2 API, safety features, typical production use cases, and a practical deployment checklist.