pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Jim C. Nasby <decibel@decibel.org>
To: Jeffrey W. Baker <jwbaker@acm.org>
Cc: Vivek Khera <khera@kcilink.com>
Cc: pgsql-general@postgresql.org
Subject: Re: disk performance benchmarks
Date: Tue, 14 Sep 2004 16:45:40 -0500
Message-ID: <20040914214540.GJ56059@decibel.org> (raw )
In-Reply-To: <1095185498.5792.12.camel@localhost.localdomain >
References: <cha71k$3qc@odah37.prod.google.com >
<x73c1kvjxg.fsf@yertle.int.kciLink.com >
<1095185498.5792.12.camel@localhost.localdomain >
On Tue, Sep 14, 2004 at 11:11:38AM -0700, Jeffrey W. Baker wrote:
> procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
> r b swpd free buff cache si so bi bo in cs us sy id wa
> 3 0 216 13852 39656 7739724 0 0 820 2664 2868 2557 16 2 74 7
> 0 0 216 17580 39656 7736460 0 0 3024 4700 3458 4313 42 6 52 0
> 0 0 216 16428 39676 7737324 0 0 840 4248 3930 4516 0 4 89 8
> 0 1 216 18620 39672 7736920 0 0 7576 516 2738 3347 1 4 55 39
> 0 0 216 14972 39672 7738960 0 0 1992 2532 2509 2288 2 3 93 3
> 0 0 216 13564 39672 7740592 0 0 1640 2656 2581 2066 1 3 97 0
> 0 0 216 12028 39672 7742292 0 0 1688 3576 2072 1626 1 2 96 0
> 0 0 216 18364 39680 7736164 0 0 1804 3372 1836 1379 1 4 96 0
> 0 0 216 16828 39684 7737588 0 0 1432 2756 2256 1720 1 3 94 2
> 0 0 216 15452 39684 7738812 0 0 1188 2184 2384 1830 1 2 97 0
> 0 1 216 15388 39684 7740104 0 0 1336 2628 2490 1974 2 3 94 2
> 6 0 216 15424 39684 7740240 0 0 104 3472 2757 1940 3 2 92 2
> 0 0 216 14784 39700 7741856 0 0 1668 3320 2718 2332 0 3 97 0
>
> You can see there's not much progress being made there. In the
Those IO numbers look pretty high for nothing going on. Are you sure
you're not IO bound?
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
view thread (16+ messages) latest in thread
Message-ID: <20040914214540.GJ56059@decibel.org>
Permalink: ../20040914214540.GJ56059@decibel.org/
Also on: postgresql.org/message-id/20040914214540.GJ56059@decibel.org
copy link · copy postgr.es
reply 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: decibel@decibel.org, jwbaker@acm.org, khera@kcilink.com, pgsql-general@postgresql.org
Subject: Re: disk performance benchmarks
In-Reply-To: <20040914214540.GJ56059@decibel.org>
* 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