Investigate how to better control pg_boss DB usage

[infomiho]

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.