From: | khan Affan <bawag773(at)gmail(dot)com> |
---|---|
To: | postgresql(at)thewickedtribe(dot)net |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Bloated pg_catalog.pg_largeobjects |
Date: | 2024-07-22 11:21:22 |
Message-ID: | CAF4emOmFCx33fvTqROw0u++vDoRH5w0D0YHVHSgR6VRsjq7d2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I would suggest to backup your DB before doing such a thing.
Run Vaccum Full, (VACUUM FULL pg_catalog.pg_largeobject) Running this on
the system table might be risky Make sure you backup the database.
& if you are using PG version above 9.1 use Pg_repack to reclaim the space.
Note: It can be disruptive, so planning and preparing for potential
downtime is essential.
Thanks & regards
*Muhammad Affan (*아판*)*
*PostgreSQL Technical Support Engineer** / Pakistan R&D*
Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan
On Sun, Jul 21, 2024 at 3:46 AM <postgresql(at)thewickedtribe(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sandeep Thakkar | 2024-07-22 11:51:38 | Re: Windows installation problem at post-install step |
Previous Message | José María Terry Jiménez | 2024-07-22 10:35:34 | repomd.xml.asc missing in some Fedora 40 repos |