From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | kelvan <kicmcewen(at)windowslive(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: database tuning |
Date: | 2007-12-07 08:12:55 |
Message-ID: | 47590087.7030409@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
kelvan wrote:
> 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
[snip]
> 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
I'd look to the source if you care that strongly. Don't rely on any info
found on the internet unless it explicitly mentions 8.1 - these things
change. Have a look in "backend/storage/" and "backend/access/" I'd
guess (not a hacker myself).
Some thoughts though:
1. If you care that strongly about performance, start building it with 8.3
2. Does your testing show that index storage overheads are/will be a
problem? If not, I'd concentrate on the testing to make sure you've
identified the bottlenecks first.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-12-07 08:39:20 | Re: database tuning |
Previous Message | Ron Mayer | 2007-12-07 05:11:40 | Re: TB-sized databases |