Yudhvir,
I completely agree. I was just putting
together a similar email.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
From:
pgsql-performance-owner@xxxxxxxxxxxxxx
[mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Y Sidhu
Sent: Tuesday, June 19, 2007 12:49
PM
To:
pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: [PERFORM] PostgreSQL
Configuration Tool for Dummies
On 6/19/07, Francisco
Reyes <lists@xxxxxxxxxxxxxxxx>
wrote:
Campbell, Lance
writes:
> Francisco and Richard,
> Why ask about disk or raid? How would that impact any settings
in
> postgresql.conf?
If the user has 2 disks and says that he will do a lot of updates he could
put pg_xlog in the second disk.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Let's not ask about disk or raid at this level of sanity tuning. It is
important for a newbie to take the right first step. When it comes to disks, we
start talking I/O, SATA, SCSI and the varying degrees of SATA and SCSI, and
controller cards. Then we throw in RAID and the different levels therein. Add
to that, we can talk about drivers controlling these drives and which OS is
faster, more stable, etc. As you can see, a newbie would get drowned. So,
please keep it simple. I know many people on this list are Gurus. We know you
are the best in this field, but we are not and are just trying to improve what
we have.
--
Yudhvir Singh Sidhu
408 375 3134 cell
