Re: PostgreSQL Configuration Tool for Dummies

From: "Y Sidhu" <ysidhu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 17:49:01
Message-ID: b09064f30706191049r547943adka7aa0e3d051c49ff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6/19/07, Francisco Reyes <lists(at)stringsutils(dot)com> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Campbell, Lance 2007-06-19 17:53:41 Re: PostgreSQL Configuration Tool for Dummies
Previous Message D'Arcy J.M. Cain 2007-06-19 17:32:14 Re: PostgreSQL Configuration Tool for Dummies