Re: PostgreSQL Configuration Tool for Dummies - Mailing list pgsql-performance

From Campbell, Lance
Subject Re: PostgreSQL Configuration Tool for Dummies
Date
Msg-id A3AC4FA47DC0B1458C3E5396E685E63302395E5E@SAB-DC1.sab.uiuc.edu
Whole thread Raw
In response to Re: PostgreSQL Configuration Tool for Dummies  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: PostgreSQL Configuration Tool for Dummies
List 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@stringsutils.com]
Sent: Tuesday, June 19, 2007 11:58 AM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.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?

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies
Next
From: Richard Huxton
Date:
Subject: Re: Maintenance question / DB size anomaly...