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

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 (view raw or flat)
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

pgsql-performance by date

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

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