From: Ray Stell <stellr@cns.vt.edu>
To: Y Sidhu <ysidhu@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: Tue, 19 Jun 2007 16:09:14 -0400
Message-ID: <20070619200914.GE16830@cns.vt.edu> (raw)
In-Reply-To: <b09064f30706191049r547943adka7aa0e3d051c49ff@mail.gmail.com>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E5D@SAB-DC1.sab.uiuc.edu>
<cone.1182272306.539173.90929.5001@35st.simplicato.com>
<A3AC4FA47DC0B1458C3E5396E685E63302395E5E@SAB-DC1.sab.uiuc.edu>
<cone.1182273956.369342.90929.5001@35st.simplicato.com>
<b09064f30706191049r547943adka7aa0e3d051c49ff@mail.gmail.com>
On Tue, Jun 19, 2007 at 10:49:01AM -0700, Y Sidhu wrote:
> On 6/19/07, Francisco Reyes <lists@stringsutils.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.
Ignoring the i/o subsystem in db configuration, there's an idea.
You could request some bonnie++ output (easy to aquire) as a baseline,
do your magic analysis based on this, and skip it if it is not provided
with a warning. Course the magic may be harder to come by.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stellr@cns.vt.edu, ysidhu@gmail.com
Subject: Re: PostgreSQL Configuration Tool for Dummies
In-Reply-To: <20070619200914.GE16830@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox