Postgres Pro
Downloads
Home   >   mailing lists

What is pg_attribute_relid_attnam_index? - Mailing list pgsql-admin

From Dirk Lutzebäck
Subject What is pg_attribute_relid_attnam_index?
Date
Msg-id 3F855B2E.7000204@aeccom.com
Whole thread Raw
Responses Re: What is pg_attribute_relid_attnam_index?  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-admin
Tree view 
Hi,

can somebody please explain what these two system indexes are:

pg_attribute_relid_attnam_index

pg_attribute_relid_attnum_index

the first one is the largest relation in terms of relpages in my
database. The latter comes at the third. Why are they so big?

Thanks,

Dirk

pgsql-admin by date:

Previous
From: shyamperi@davlin.co.in
Date:
Subject: Serious Problem with the windows and postgres configuration
Next
From: Andrew Sullivan
Date:
Subject: Re: What is pg_attribute_relid_attnam_index?