size of attributes table is too big

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: size of attributes table is too big
Date: 2025-03-19 17:06:08
Message-ID: CAC5iy61zUBySCMFH3JSKd6W922nV3fHMpXi+qUuPvXQ3shuOBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

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?

Here are the sizes:

pg_attribute
338 GB
pg_attribute_relid_attnam_index
117 GB
pg_attribute_relid_attnum_index
69 GB

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.

REgards
Siraj

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Álvaro Herrera 2025-03-19 17:13:44 Re: size of attributes table is too big
Previous Message Adrian Klaver 2025-03-19 16:53:31 Re: After upgrading libpq, the same function(PQftype) call returns a different OID