From: Simon Riggs <simon@2ndquadrant.com>
To: kelvan <kicmcewen@windowslive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: database tuning
Date: Fri, 07 Dec 2007 08:39:20 +0000
Message-ID: <1197016760.4255.474.camel@ebony.site> (raw)
In-Reply-To: <fja1je$2c22$1@news.hub.org>
References: <fja1je$2c22$1@news.hub.org>
On Fri, 2007-12-07 at 12:45 +1200, 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
If your need-for-speed is so high, I would suggest using 8.3 or at least
looking at the 8.3 documentation.
This release is very nearly production and is much faster than 8.1 or
8.2. You may not have realised that Postgres dot releases are actually
major releases and have significant speed differences.
There's not much to be done about the overheads you mention, so best to
concentrate your efforts on index planning for your most frequently
executed queries.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: simon@2ndquadrant.com, kicmcewen@windowslive.com
Subject: Re: database tuning
In-Reply-To: <1197016760.4255.474.camel@ebony.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox