On Thu, 2021-01-28 at 13:18 +0000, Zwettler Markus (OIZ) wrote: > Short question. Is it recommended - or even best practice – to run vacuumlo > periodically as a routine maintenance task? > > We don't do it. I think if this would be recommended it would have been > implemented as an autotask like autovacuum. No?
It is recommended to run it regularly if - you are using large objects - you don't have a trigger in place that deletes large objects that you don't need any more Only a small minority of people do that, so it wouldn't make sense to automatically run that on all databases. Avoid large objects if you can. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
