Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BBBD62E0090 for ; Thu, 6 Dec 2007 19:50:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 67242-07 for ; Thu, 6 Dec 2007 19:49:56 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 33DFE2E004D for ; Thu, 6 Dec 2007 19:50:02 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lB6NnvB7079292 for ; Thu, 6 Dec 2007 19:49:57 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lB6NjpFo077901 for pgsql-performance@postgresql.org; Thu, 6 Dec 2007 19:45:51 -0400 (AST) (envelope-from news) From: "kelvan" X-Newsgroups: pgsql.performance Subject: database tuning Date: Fri, 7 Dec 2007 12:45:26 +1200 Organization: Hub.Org Networking Services Lines: 31 Message-ID: Reply-To: "kelvan" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/88 X-Sequence-Number: 27904 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 I have gathered some relevant information form the documentation such as all the data type sizes and the RM block information but I don't have any information on INDEX blocks or other general overheads http://www.peg.com/techpapers/monographs/space/space.html http://www.postgresql.org/docs/8.1/static/datatype.html 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 Regards Kelvan