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

Re: Configuration/Tuning of server/DB

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Reid Thompson <jreidthompson(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration/Tuning of server/DB
Date: 2005-03-28 15:44:49
Message-ID: (view raw or whole thread)
Lists: pgsql-performance

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:


general tuning


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

Strategic Open Source — Open Your i™
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320

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(at)postgresql(dot)org

In response to

pgsql-performance by date

Next:From: Stephan SzaboDate: 2005-03-28 16:27:36
Subject: Re: Delete query takes exorbitant amount of time
Previous:From: Rudi StarcevicDate: 2005-03-28 15:34:38
Subject: NFS RAID 0/5

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