Message-ID: <47590087.7030409@archonet.com>
Date: Fri, 07 Dec 2007 08:12:55 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.9 (X11/20071031)
MIME-Version: 1.0
To: kelvan <kicmcewen@windowslive.com>
CC: pgsql-performance@postgresql.org
Subject: Re: database tuning
References: <fja1je$2c22$1@news.hub.org>
In-Reply-To: <fja1je$2c22$1@news.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

kelvan wrote:
> hi i need to know all the database overhead sizes and block header sizes etc 
> etc as I have a very complex database to build and it needs to be speed 
> tuned beyond reckoning

[snip]

> I am using postgres 8.1 if anyone can post links to pages containing over 
> head information and index block header information it would be most 
> appreciated as I cannot seem to find anything

I'd look to the source if you care that strongly. Don't rely on any info 
found on the internet unless it explicitly mentions 8.1 - these things 
change. Have a look in "backend/storage/" and "backend/access/" I'd 
guess (not a hacker myself).


Some thoughts though:
1. If you care that strongly about performance, start building it with 8.3

2. Does your testing show that index storage overheads are/will be a 
problem? If not, I'd concentrate on the testing to make sure you've 
identified the bottlenecks first.

-- 
   Richard Huxton
   Archonet Ltd