PostgreSQL Configuration Tool for Dummies

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 18:15:59
Message-ID: A3AC4FA47DC0B1458C3E5396E685E63302395E63@SAB-DC1.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Below is a link to the HTML JavaScript configuration page I am creating:

http://www.webservices.uiuc.edu/postgresql/

I had many suggestions. Based on the feedback I received, I put
together the initial list of questions. This list of questions can be
change.

Memory

There are many different ways to ask about memory. Rather than ask a
series of questions I went with a single question, #2. If it is better
to ask about the memory in a series of questions then please give me the
questions you would ask and why you would ask each of them. From my
understanding the primary memory issue as it relates to PostgreSQL is
"how much memory is available to PostgreSQL". Remember that this needs
to be as simple as possible.

My next step is to list the PostgreSQL parameters found in the
postgresql.conf file and how I will generate their values based on the
questions I have so far. I will primarily focus on PostgreSQL 8.2.x.
Once I have a consensus from everyone then I will put functionality
behind the "Generate Suggested Settings" button.

Thanks for all of the feedback,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Y Sidhu 2007-06-19 18:37:53 Re: PostgreSQL Configuration Tool for Dummies
Previous Message Campbell, Lance 2007-06-19 18:09:25 Re: PostgreSQL Configuration Tool for Dummies