Nice article , also worth mentioning vacuuming “orphaned” large objects. Docs here: https://www.postgresql.org/docs/current/vacuumlo.html

https://www.postgresql.org/docs/current/sql-vacuum.html