pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas F.O'Connell <tfo@sitening.com>
To: Reid Thompson <jreidthompson@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuration/Tuning of server/DB
Date: Mon, 28 Mar 2005 09:44:49 -0600
Message-ID: <85e32fe05043b0bc0e94258bd9160024@sitening.com> (raw)
In-Reply-To: <d1v5ev$1cdc$1@news.hub.org>
References: <d1v5ev$1cdc$1@news.hub.org>

Reid,

There are a few very valuable tuning documents that are part of the  
established PostgreSQL-related literature. You don't mention which  
version of postgres you'll be running, but here are the documents  
you'll find useful:

postgresql.conf
7.4:  
http://www.varlena.com/varlena/GeneralBits/Tidbits/ 
annotated_conf_e.html
8.0: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html

general tuning
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source — Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Mar 24, 2005, at 1:46 PM, Reid Thompson wrote:

> Using information found on the web, I've come up with some  
> configuration and tuning parameters for a server/db that we will be  
> implementing.  I was wondering if I could generate some feedback as to  
> configuration and tuning so that I could compare my estimations with  
> those of others.
>
> Host is AIX 5.1 with 4 cpu's and 4 GB ram.  Postgresql will be sharing  
> this machine with other processes.  Storage is an EMC storage array.  
> The DB itself is very simple.  Two tables, one with 40-45 columns (  
> largest column will likely contain no more than 32 chars of data ),  
> the other with less than 5 columns ( largest column will contain no  
> more than 20 chars data ).  Expected transactions will be along the  
> order of ~600K +- 100K inserts and ~600K +-200K updates per week.
>
> Thanks
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to  
> majordomo@postgresql.org




view thread (2+ messages)

Message-ID: <85e32fe05043b0bc0e94258bd9160024@sitening.com>
Permalink:  ../85e32fe05043b0bc0e94258bd9160024@sitening.com/
Also on:    postgresql.org/message-id/85e32fe05043b0bc0e94258bd9160024@sitening.com

 · 

reply

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: tfo@sitening.com, jreidthompson@earthlink.net
  Subject: Re: Configuration/Tuning of server/DB
  In-Reply-To: <85e32fe05043b0bc0e94258bd9160024@sitening.com>

* 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