Onpremise Retool PostgreSQL size

[Jen]

Hi @Jorge!

There is no UI option to clean up page_saves table on on-prem, but you can run the built-in script in the backend (available for self-hosted 3.178+):

./retool_backend --run-pagesave-compaction

I would also like to mention that Alice from Retool Support team has created this post about reducing your Retool database size that might be helpful:

How to reduce your Retool main storage DB size (self-hosted)

Retool's main storage database can grow unexpectedly due to two tables: page_saves: stores every autosave of every app. Independent of Git version control. Deleting from Git does not shrink this. audit_trail_events: stores audit log events. On self-hosted, retention is manual only. Before you start Take a backup of the main storage DB. Every option below is destructive. Test on staging first. Not just backup, actually run the same operation on a non-prod copy. For manual DELETEs, run them i…

Hope this helps! Let me know if you need anything else at this time

-Jen