database physical storage - Mailing list pgsql-admin

From Praveen Kumar N
Subject database physical storage
Date
Msg-id Pine.LNX.4.61.0606151016070.15974@students.iiit.net
Whole thread Raw
Responses Re: database physical storage  (Michael Fuhr <mike@fuhr.org>)
List 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


pgsql-admin by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: Table truncate question
Next
From: Robin Iddon
Date:
Subject: Re: autovacuum