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

Re: database tuning

From: Simon Riggs <simon(at)2ndquadrant(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:39:20
Message-ID: 1197016760.4255.474.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

Responses

pgsql-performance by date

Next:From: Guillaume CottenceauDate: 2007-12-07 10:50:19
Subject: Cost-Based Vacuum Delay tuning
Previous:From: Richard HuxtonDate: 2007-12-07 08:12:55
Subject: Re: database tuning

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