Re: PostgreSQL Configuration Tool for Dummies

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: "Francisco Reyes" <lists(at)stringsutils(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 17:03:10
Message-ID: A3AC4FA47DC0B1458C3E5396E685E63302395E5E@SAB-DC1.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Francisco and Richard,
Why ask about disk or raid? How would that impact any settings in
postgresql.conf?

I did forget the obvious question:

What OS are you using?

Thanks,

Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu

-----Original Message-----
From: Francisco Reyes [mailto:lists(at)stringsutils(dot)com]
Sent: Tuesday, June 19, 2007 11:58 AM
To: Campbell, Lance
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

Campbell, Lance writes:

> 3) I suggested JavaScript because most people that get started with
> PostgreSQL will go to the web in order to find out about issues
relating

Why not c?
It could then go into contrib.
Anyways.. language is likely the least important issue..
As someone mentioned.. once the formulas are worked out it can be done
in a
few languages.. as people desire..

> How much memory will be available to PostgreSQL?
> How many connections will be made to PostgreSQL?

Will this be a dedicated Postgresql server?
Will there be mostly reads or will there also be significant amount of
writes?

Are you on a RAID system or do you have several disks over which you
would
like to run postgresql on?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-06-19 17:04:50 Re: Maintenance question / DB size anomaly...
Previous Message Francisco Reyes 2007-06-19 16:58:26 Re: PostgreSQL Configuration Tool for Dummies