Home > mailing lists

size of attributes table is too big - Mailing list pgsql-general

From	Siraj G
Subject	size of attributes table is too big
Date	March 19 20:06:08
Msg-id	CAC5iy61zUBySCMFH3JSKd6W922nV3fHMpXi+qUuPvXQ3shuOBg@mail.gmail.com Whole thread Raw
Responses	Re: size of attributes table is too big Re: size of attributes table is too big Re: size of attributes table is too big
List	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

From: Adrian Klaver
Date: 19 March, 19:53:31
Subject: Re: After upgrading libpq, the same function(PQftype) call returns a different OID

From: Álvaro Herrera
Date: 19 March, 20:13:44
Subject: Re: size of attributes table is too big