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
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) |