wasp
wasp copied to clipboard
Investigate how to better control `pg_boss` DB usage
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.