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 space occupied 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 index does not. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4baf3c0010411382482531! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general