From: Reid Thompson <jreidthompson@earthlink.net>
To: pgsql-performance@postgresql.org
Subject: Configuration/Tuning of server/DB
Date: Thu, 24 Mar 2005 14:46:41 -0500
Message-ID: <d1v5ev$1cdc$1@news.hub.org> (raw)
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
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: jreidthompson@earthlink.net
Subject: Re: Configuration/Tuning of server/DB
In-Reply-To: <d1v5ev$1cdc$1@news.hub.org>
* 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