wasp icon indicating copy to clipboard operation
wasp copied to clipboard

Investigate how to better control `pg_boss` DB usage

Open infomiho opened this issue 4 months ago • 0 comments

In one of our example apps, pg_boss filled up 1 GB of DB data without much usage.

The demo app was hosted on Supabase and we exceeded their free plan limits.

Upon investigation, I found ~500MB in the pg_boss.jobs table and ~500MB in the pg_boss.archive table. It seems that PgBoss keeps track of all executed scheduled jobs and their results. It also moves stuff to the archive table after some time.

We should investigate how this works exactly and offer our users a way to control the data retention time.

infomiho avatar Oct 01 '24 09:10 infomiho