| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: running vacuumlo periodically? |
| Date: | 2021-01-28 16:39:02 |
| Message-ID: | 0c6514ab0ef287b40e818280754d087d210a0164.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yambu | 2021-01-28 16:44:37 | Postgres freelancing sites |
| Previous Message | Alvaro Herrera | 2021-01-28 16:01:48 | Re: How to post to this mailing list from a web based interface |