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

Re: PostgreSQL Configuration Tool for Dummies

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: "Y Sidhu" <ysidhu(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 17:53:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

I completely agree.  I was just putting together a similar email.




Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois




From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Y Sidhu
Sent: Tuesday, June 19, 2007 12:49 PM
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] PostgreSQL Configuration Tool for Dummies



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
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

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-06-19 17:57:41
Subject: Re: Performance query about large tables, lots of concurrent access
Previous:From: Y SidhuDate: 2007-06-19 17:49:01
Subject: Re: PostgreSQL Configuration Tool for Dummies

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