| 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: | Whole Thread | Raw Message | 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) |