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 Jim Hurne
Subject RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Date
Msg-id OFB99C007D.CA15CC8E-ON85258591.004ECAD1-85258591.004F258D@notes.na.collabserv.com
Whole thread Raw
In response to RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  (Thomas Boussekey <thomas.boussekey@gmail.com>)
List pgsql-general
Tree view 
"Daniel Verite" <daniel@manitou-mail.org> wrote on 06/24/2020 10:08:27 AM:
> Unfortunately it [pg_repack] can't work with pg_largeobject

That is unfortunate, and potentially leaves us in a difficult spot.

Is it possible to configure PosgreSQL to use a user table for large
objects instead of a system table?

We're finding it to be especially difficult to maintain the pg_largeobject
system table (tweak autovacuum settings, manually cleanup with something
like pg_repack, etc), particularly since our PosrgreSQL instances are
hosted and controlled by another team.

Regards,

Jim Hurne

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgbench and timestamps
Next
From: Tom Lane
Date:
Subject: Re: pgbench and timestamps