X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2F3C29FA4A6 for ; Thu, 15 Jun 2006 01:57:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44295-07 for ; Thu, 15 Jun 2006 01:57:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from students.iiit.net (students.iiit.ac.in [202.65.145.5]) by postgresql.org (Postfix) with ESMTP id 191909FA4C1 for ; Thu, 15 Jun 2006 01:57:18 -0300 (ADT) Received: from students.iiit.net (localhost.localdomain [127.0.0.1]) by students.iiit.net (8.13.6/8.13.0) with ESMTP id k5F4v0Bb019177 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 15 Jun 2006 10:27:00 +0530 Received: from localhost (praveen_n@localhost) by students.iiit.net (8.13.6/8.12.8/Submit) with ESMTP id k5F4uxMa019174 for ; Thu, 15 Jun 2006 10:26:59 +0530 Date: Thu, 15 Jun 2006 10:26:59 +0530 (IST) From: Praveen Kumar N To: pgsql-admin@postgresql.org Subject: database physical storage Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-IIITH-MailScanner-Information: Please contact the IIIT Server Room for more information X-IIITH-MailScanner: Found to be clean X-IIITH-MailScanner-From: praveen_n@students.iiit.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/125 X-Sequence-Number: 22087 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