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

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Jim Hurne" <jhurne(at)us(dot)ibm(dot)com>
Cc: "PostgreSQL General" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Date: 2020-06-24 14:08:27
Message-ID: 001489c4-3234-4ebb-916a-bb490a42e9f8@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jim Hurne wrote:

> "Daniel Verite" <daniel(at)manitou-mail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-24 14:15:23 Re: pgbench and timestamps
Previous Message Jim Hurne 2020-06-24 13:48:15 RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked