What is pg_attribute_relid_attnam_index?

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: What is pg_attribute_relid_attnam_index?
Date: 2003-10-09 12:57:18
Message-ID: 3F855B2E.7000204@aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott 2003-10-09 13:44:28 Oracle takes the wraps off SME database
Previous Message shyamperi 2003-10-09 12:16:16 Serious Problem with the windows and postgres configuration