Link to the long story happened before (and reason to have) this question.
Does AWS ever
vacuumlo PostgreSQL RDS instances?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Probably not, because blindly executing
vacuumlo on random databases would be foolish.
vacuum that is pretty much unavoidable on a normal live database,
vacuumlo fixes an oversight, a situation that should not arise in the first place, since applications should unlink the large objects that they no longer use, at about the same time that they delete the references to these large objects.
In a database with a large number of large objects that are properly handled,
vacuumlo would burn CPU cycles and I/O at each invocation, just to compute every single time that there is nothing to remove.
Moreover, there are two assumptions that
vacuumlo must do that are debatable:
oidshould be taken as a candidate to a large object reference.
oidare used for other purposes, especially if you want to refer to objects in the catalog.