RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked

    Jim Hurne wrote:

> "Daniel Verite" <daniel@manitou-mail.org> wrote on 06/22/2020 06:00:37 PM:
> > If you can arrange a maintenance window, a faster way to rebuild
> > pg_largeobject when it contains mostly empty pages can be to:
>
> Thanks Daniel. If we cannot arrange for a maintenance window, is this the
> sort of thing that pg_repack[1] could be used to do?

Unfortunately it can't work with pg_largeobject:

https://github.com/reorg/pg_repack/issues/163


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: https://www.manitou-mail.org
Twitter: @DanielVerite