Postgres Pro
Downloads
Home   >   mailing lists

Re: Bloated pg_catalog.pg_largeobjects - Mailing list pgsql-general

From Priancka Chatz
Subject Re: Bloated pg_catalog.pg_largeobjects
Date
Msg-id CANnOdgb0sJqjPxHmRuJPkJh4ig1xhDvcQBcXAm01ujUe+4L=2g@mail.gmail.com
Whole thread Raw
In response to Bloated pg_catalog.pg_largeobjects  (postgresql@thewickedtribe.net)
List pgsql-general
Tree view
You have to run vacuumlo to remove orphaned large objects. 
Regards,
Priyanka 

On Sun, 21 Jul 2024 at 12:46 AM, <postgresql@thewickedtribe.net> wrote:

Hello All,

I've got a cluster that's having issues with pg_catalog.pg_largeobject getting massively bloated. Vacuum is running OK and there's 700GB of free space in the table and only 100GB of data, but subsequent inserts seem to be not using space from the FSM and instead always allocating new pages. The table just keeps growing.

Is this a known thing, maybe something special about LOs?

Also, is the only way to recover space here a vacuum full on the table since it's a catalog table?

Thanks,

-- 
Jon Erdman (aka StuckMojo on IRC)
    PostgreSQL Zealot

pgsql-general by date:

Previous
From: postgresql@thewickedtribe.net
Date:
Subject: Bloated pg_catalog.pg_largeobjects
Next
From: Ertan Küçükoglu
Date:
Subject: Windows installation problem at post-install step