Index size - Mailing list pgsql-general

From Ioannis Theoharis
Subject Index size
Date
Msg-id Pine.GSO.4.58.0503011546140.10218@ourania.ics.forth.gr
Whole thread Raw
Responses Re: Index size
List pgsql-general

Hi,

I have created a btree index on a 'int4' attribute of a table.

After i have inserted 1,000,000 raws in my table, i can see that my index
size is 2745 Blocks (8KB each) from pg_class. That means about 21,960 KB
size.

I try to understand hows is this number generated, because thought that
for each new entry in table, there is a new entry in index and that each
entry of the index is:

4 Bytes for the int4 attribute
and
40 Bytes for oid

So 44 * 1,000,000 ~ 42,969 KB

Can anybody inform me where I do the mistake?


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problem with pg_hba.conf
Next
From: celerity12
Date:
Subject: Problem with pg_hba.conf