Re: Why index occupy less amount of space than the table with same structure.

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why index occupy less amount of space than the table with same structure.
Date: 2010-03-29 08:15:00
Message-ID: EDDCA3F9-2FAA-44BA-96E9-21E260E03254@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29 Mar 2010, at 6:03, Tadipathri Raghu wrote:

> Hi Alban,
>
> Thank you for the update.
>
> For one thing: The table holds information regarding to which transactions each row is visible (the xid) whereas the index does not.
>
> What would be the each value of the xid, like 8 bytes,or 32 bytes..which causing the table to hold what index is not and the space occupied is exactly half of the table in indexes. Can you explain a bit on this.

I'm pretty sure the documentation explains this better than I can.

Alban Hertroys

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

!DSPAM:737,4bb0618a10411369417804!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Eisserer 2010-03-29 08:22:59 looking for a powerful frontend/teport generator
Previous Message Frans Hals 2010-03-29 07:39:35 Re: Large index operation crashes postgres