Message-ID: <483513EB.6080500@Sheeky.Biz>
Date: Thu, 22 May 2008 16:04:19 +0930
From: Shane Ambler <pgsql@Sheeky.Biz>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: Duan Ligong <l-duan@zd.cnes.jp.nec.com>
CC: Scott Marlowe <scott.marlowe@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: ]To estimate the size of db
References: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp>
	<dcc563d10805211208l27b6cb1as5951112bf504ffaa@mail.gmail.com>
	<00ba01c8bba8$5b402750$f623480a@nsl.ad.nec.co.jp>
In-Reply-To: <00ba01c8bba8$5b402750$f623480a@nsl.ad.nec.co.jp>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Duan Ligong wrote:
> I mean I want to estimate the size of the space which the db will occupy.
> Now there is no db.

With a bit of math and the info here -
http://www.postgresql.org/docs/8.3/interactive/storage-page-layout.html
you can start to get an idea.

Simple calculation would be 23 bytes overhead per row + length of data 
in columns with one or two extra overhead on some types (like length of 
string or array) also don't forget that text may be more than one byte 
per char.

A similar estimate for indexes can come into play as well.

The final size will likely be a bit larger as you also get issues like 
data alignment and unused space on a page that doesn't fit a row...


-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz