Re: running vacuumlo periodically? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: running vacuumlo periodically?
Date
Msg-id 0c6514ab0ef287b40e818280754d087d210a0164.camel@cybertec.at
Whole thread Raw
In response to running vacuumlo periodically?  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Responses AW: running vacuumlo periodically?
List pgsql-general
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




pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How to post to this mailing list from a web based interface
Next
From: Yambu
Date:
Subject: Postgres freelancing sites