database tuning

From: "kelvan" <kicmcewen(at)windowslive(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: database tuning
Date: 2007-12-07 00:45:26
Message-ID: fja1je$2c22$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Mayer 2007-12-07 01:28:24 Re: TB-sized databases
Previous Message Mark Cave-Ayland 2007-12-06 20:10:08 Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)