| From: | Praveen Kumar N <praveen_n(at)students(dot)iiit(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | database physical storage |
| Date: | 2006-06-15 04:56:59 |
| Message-ID: | Pine.LNX.4.61.0606151016070.15974@students.iiit.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
hai...
I have observed that the size of data (for example size of
table in a database) stored by database system on physical storage is
more than actual datasize.It seems database is storing data in some
format.For example i have created a table with data 15MB considering each
INTEGER of 4bytes.But after loading this data into database i have
observed that database system is storing this table in 45MB memory.So can
anybody tell me what is the reason to use so much memory? Is there any
relation between actual dataset size and size of data stored on physical
storage system.
thanks in anticipation
regards,
--
N Praveen Kumar
Imagination is more important than knowledge...
--Albert Einstein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robin Iddon | 2006-06-15 11:20:19 | Re: autovacuum |
| Previous Message | Brad Nicholson | 2006-06-14 21:02:25 | Re: Table truncate question |