Re: running vacuumlo periodically?

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