Postgres Pro
Downloads
Home   >   mailing lists

Re: Why index occupy less amount of space than the table with same structure. - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Why index occupy less amount of space than the table with same structure.
Date
Msg-id C87734EA-B114-4E1E-83A2-09043E86E2A9@solfertje.student.utwente.nl
Whole thread Raw
In response to Why index occupy less amount of space than the table with same structure.  (Tadipathri Raghu <traghu.dba@gmail.com>)
Responses Re: Why index occupy less amount of space than the table with same structure.
List pgsql-general
Tree view 
On 28 Mar 2010, at 10:05, Tadipathri Raghu wrote:

> Hi All,

...

> I like to know here is, I have created a table with one column and the index is on one column only, so why is the
spaceoccupied differently, almost all half of the space of the table and why not full. Could please you explain on
this.And what exactly the postgres architecture treat on Index table and Ordinary table. 

For one thing: The table holds information regarding to which transactions each row is visible (the xid) whereas the
indexdoes not. 

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4baf3c0010411382482531!

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Designing Postgres Security Model
Next
From: Tom Lane
Date:
Subject: Re: simultaneously reducing both memory usage and runtime for a query