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

From: "Jim Hurne" <jhurne(at)us(dot)ibm(dot)com>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
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 13:48:15
Message-ID: OF83861189.C9BB76A1-ON85258591.004BA3E3-85258591.004BD464@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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?

Would pg_repack require setting allow_system_table_mods to on?

[1] https://github.com/reorg/pg_repack

Regards,

Jim Hurne

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2020-06-24 14:08:27 RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Previous Message Jaime Soler 2020-06-24 13:12:45 Re: pgbench and timestamps