We are using a Postgres database (9.3) as our production database. It is generating huge lo objects. Due to this, the size is growing very fast. So we need to do database cleaning frequently. To remove these lo objects we are having long downtimes.
To clean the DB, we are performing the below steps in sequence:
vacuumdb database_name -t pg_largeobject
vacuumdb database_name -t pg_largeobject_metadata
reindexdb -t pg_largeobject database_name
reindexdb -t pg_largeobject_metadata database_name
Can we do the above online (during the night) without having any downtime?