From: kelvan <kicmcewen@windowslive.com>
To: pgsql-performance@postgresql.org
Subject: database tuning
Date: Fri, 7 Dec 2007 12:45:26 +1200
Message-ID: <fja1je$2c22$1@news.hub.org> (raw)
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.htmlhttp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kicmcewen@windowslive.com
Subject: Re: database tuning
In-Reply-To: <fja1je$2c22$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox