Postgres Pro
Downloads
Home   >   mailing lists

RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked - Mailing list pgsql-general

From Daniel Verite
Subject RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Date
Msg-id 001489c4-3234-4ebb-916a-bb490a42e9f8@manitou-mail.org
Whole thread Raw
In response to RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Responses RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
List pgsql-general
Tree view 
    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

pgsql-general by date:

Previous
From: "Jim Hurne"
Date:
Subject: RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Next
From: Tom Lane
Date:
Subject: Re: pgbench and timestamps