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