RepoJournal
Supabase

@supabase

The open-source Firebase alternative powering thousands of startups

Keep up with Supabase in about 3 minutes a day: what actually shipped — the commits, pull requests, releases, and security advisories that matter.

One email a day. Unsubscribe in one click.

Pick a date

Topics: JavaScript Full archive →

The Wire · Showcase

PG-BOSS PATCHES STATEMENT TIMEOUT THAT KILLS MAINTENANCE JOBS AT SCALE

By RepoJournal · Filed · About Supabase

pg-boss just stopped keeling over when your job backlog grows, fixing a 30-second timeout that was nuking archive and purge operations in production.

The culprit: unbounded DELETE queries inside maintenance cycles that would hang indefinitely on tables with large backlogs [1]. The fix batches both operations with hard limits, wrapping the archive DELETE in a USING subquery with a 10,000-row cap per cycle and the purge DELETE with a 20,000-row cap [1]. This keeps transactions well under the 30-second statement_timeout set in the locked() wrapper, so your maintenance jobs actually finish instead of timing out and leaving dead jobs piling up [1]. If you're running pg-boss in production with accumulated job history, this is the patch that stops your database from gradually choking itself.

One email a day. Unsubscribe in one click.

Action items

References

  1. [1] fix: batch archive and purge queries to prevent statement timeout ↗ supabase/pg-boss

Quick answers

What shipped in Supabase on May 17, 2026?
pg-boss just stopped keeling over when your job backlog grows, fixing a 30-second timeout that was nuking archive and purge operations in production. In total, 3 commits and 1 pull requests landed.
Who contributed to Supabase on May 17, 2026?
1 developer shipped this update, including Crispy1975.
What were the notable Supabase updates?
fix: batch archive and purge queries to prevent statement timeout.

More from @supabase

Daily updates, in your inbox

Follow Supabase

Keep up with Supabase in about 3 minutes a day: what actually shipped — the commits, pull requests, releases, and security advisories that matter.

or

One email a day. Unsubscribe in one click. Read a past issue →

Elsewhere on the wire

Want every project, not just this one?