Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 48B492E2D6C
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 11 Dec 2007 18:27:59 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 79503-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 11 Dec 2007 18:27:51 -0400 (AST)
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by postgresql.org (Postfix) with ESMTP id DE6152E2D5B
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Dec 2007 18:27:54 -0400 (AST)
Received: from perhan.alvh.no-ip.org (200-126-76-117.bk5-dsl.surnet.cl
	[200.126.76.117]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBBMRoBT024255
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Tue, 11 Dec 2007 14:27:52 -0800
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id CE5F247C87; Tue, 11 Dec 2007 19:27:48 -0300 (CLST)
Date: Tue, 11 Dec 2007 19:27:48 -0300
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: kelvan <kicmcewen@windowslive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: database tuning
Message-ID: <20071211222748.GA31196@alvh.no-ip.org>
References: <fja1je$2c22$1@news.hub.org>
 <1197016760.4255.474.camel@ebony.site>
	<fjc2hb$2cd3$1@news.hub.org>
	<dcc563d10712100858j7b55e68co5d0da0f8b82c19b1@mail.gmail.com>
	<fjki5a$uf1$1@news.hub.org>
	<Pine.GSO.4.64.0712101912340.14776@westnet.com>
	<fjn2d5$5al$1@news.hub.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <fjn2d5$5al$1@news.hub.org>
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Tue, 11 Dec 2007 14:27:53 -0800 (PST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/151
X-Sequence-Number: 27967

kelvan wrote:

I wonder where did all the punctuation symbols on your keyboard went.
Your email is amazingly hard to read.

> overhead information i would to know is row overheads column overheads and 
> header overheads for blocks and anything else i have missed

As for storage overhead, see here:

http://www.postgresql.org/docs/8.3/static/storage-page-layout.html


-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)