Skip site navigation (1) Skip section navigation (2)

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$ (view raw or whole 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

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




pgsql-performance by date

Next:From: Ron MayerDate: 2007-12-07 01:28:24
Subject: Re: TB-sized databases
Previous:From: Mark Cave-AylandDate: 2007-12-06 20:10:08
Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not2005)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group