public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pavel Stehule <[email protected]>
To: Álvaro Herrera <[email protected]>
Cc: Siraj G <[email protected]>
Cc: [email protected]
Subject: Re: size of attributes table is too big
Date: Wed, 19 Mar 2025 18:16:57 +0100
Message-ID: <CAFj8pRDhfOs5mDQNL7D7Z+CxX6ceXppQFLCOYPQKmLqH3BHotg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAC5iy61zUBySCMFH3JSKd6W922nV3fHMpXi+qUuPvXQ3shuOBg@mail.gmail.com>
	<[email protected]>

st 19. 3. 2025 v 18:14 odesílatel Álvaro Herrera <[email protected]>
napsal:

> Hello
>
> On 2025-Mar-19, Siraj G wrote:
>
> > I have a PG (v16) instance which is occupying around 1TB of storage. Out
> of
> > this, around 350GB is occupied by the table pg_catalog.pg_attribute.
> > Why is the catalog table's size so big?
>
> Heavy use of temp tables is a known cause of this.
>
> > I think this table must have tons of dead tuples. Please suggest to me if
> > we can purge any data/shrink the size of this table.
>
> Yeah, I'd also bet that there are tons of dead tuples, or just unused
> free space.  To purge it you would use VACUUM FULL, though that would
> need to lock all accesses to the table.
>
> Does your instance run with autovacuum disabled perchance?
>

or long unclosed transactions, maybe forgotten replication slots, ...

It is very strange so with this size it is still usable. Today hardware is
unbelievable strong

Regards

Pavel


>
> --
> Álvaro Herrera         PostgreSQL Developer  —
> https://www.EnterpriseDB.com/
> Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
> stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
> After collecting 500 such letters, he mused, a university somewhere in
> Arizona would probably grant him a degree.              (Don Knuth)
>
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: size of attributes table is too big
  In-Reply-To: <CAFj8pRDhfOs5mDQNL7D7Z+CxX6ceXppQFLCOYPQKmLqH3BHotg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox