From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Date: Tue, 11 Sep 2007 20:10:50 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0709112005300.28383@westnet.com> (raw)
In-Reply-To: <87r6l4ajqh.fsf@oxford.xeocode.com>
References: <C30B1716.4236C%llonergan@greenplum.com>
<87lkbdlkxw.fsf@oxford.xeocode.com>
<46E676D6.70807@verizon.net>
<87zlzt9ifw.fsf@oxford.xeocode.com>
<46E6E338.5050403@verizon.net>
<20070911213105.GF38801@decibel.org>
<87r6l4ajqh.fsf@oxford.xeocode.com>
On Wed, 12 Sep 2007, Gregory Stark wrote:
> Also, it helps to run a "vmstat 1" in another window and watch the bi and bo
> columns.
Recently on Linux systems I've been using dstat (
http://dag.wieers.com/home-made/dstat/ ) for live monitoring in this sort
of situation. Once you get the command line parameters right, you can get
data for each of the major disks on your system that keep the columns
human readable (like switching from KB/s to MB/s as appropriate) as
activity goes up and down combined with the standard vmstat data.
I still use vmstat/iostat if I want to archive or parse the data, but if
I'm watching it I always use dstat now.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
In-Reply-To: <Pine.GSO.4.64.0709112005300.28383@westnet.com>
* 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