RepoJournal
Supabase

@supabase

The open-source Firebase alternative powering thousands of startups

Pick a date

  1. Sat 2 may
  2. Mon 4 may
  3. Tue 5 may
  4. Wed 6 may
  5. Thu 7 may
  6. Fri 8 may
  7. Sat 9 may
  8. Mon 11 may
  9. Tue 12 may
  10. Wed 13 may
  11. Thu 14 may
  12. Fri 15 may
  13. Sat 16 may
  14. Sun 17 may
  15. Tue 19 may
  16. Wed 20 may
  17. Thu 21 may
  18. Sat 23 may
  19. Sun 24 may
  20. Mon 25 may
  21. Tue 26 may
  22. Wed 27 may
  23. Thu 28 may
  24. Fri 29 may
  25. Sat 30 may
  26. Sun 31 may
  27. Mon 1 jun
  28. Mon 8 jun
  29. Tue 9 jun
  30. Today 10 jun

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.

Action items

References

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

FAQ

What changed 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.
What should Supabase teams do about it?
Upgrade pg-boss to latest and redeploy • Monitor maintenance job logs for success after upgrade
Which Supabase repositories shipped on May 17, 2026?
supabase/pg-boss

Related across the cluster

For your repos

The showcase is a teaser.
Your wire is the product.

Same engine. Different stack. Below: what changes when the wire is yours.

Showcase wire

  • •14 famous open source orgs
  • •One wire per day
  • •Public, generic
  • •Read on the web, when you remember

Your wire

  • →Up to 1,500 of your repos - orgs, deps, vendors
  • →Morning and evening briefs
  • →Action items routed to your team
  • →Slack delivery, email, breaking-news CVE alerts

Want a hands-on demo first? Ask a current user for an invite link.