Database maintenence, who does what?
Hi,
Supabase is very clear about the shared responsibility of database security, and who does what. However I cant say the same for database maintenence.
- Does supabase autovacuum, can I decide at what time so I can choose daily low traffic moments?
- What about query planner stats do these also get automatically cleaned and recalculated.
- What about reindexing?
- Reclustering tables for seq scan speed?
3 Replies
https://supabase.com/docs/guides/platform/database-size#vacuum-operations
I believe autovacuum causes planner stats to also update but that is a postgres default feature, I don't think Supabase does anything special.
I don't think Postgres has any auto reindexing options and they can be very compute intensive. I don't know what 4 is but if not a built in feature of Postgres probably not.
Also you are responsible for cleaning large tables like cron.job_run_details and auth.audit_log_entries.
I see, thanks!
Is there a list in the docs of tables that would grow indefinitly or other tables i should implement something for?
I cant find anything about that and honestly wouldnt even have known that I needed to clean those
Not that I know of. Cron is an extension and the docs for it (in the repository) mention needing to add a cron task to clean it.
I look at the the large object report, but there are other ways to see the largest table in Postgres.
