From: Iain <iain@mst.co.jp>
To: Curtis Zinzilieta <curtisz@norchemlab.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Anjan Dave <adave@vantage.com>
Cc: Matt Clark <matt@ymogen.net>
Cc: Rod Taylor <pg@rbt.ca>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: Wed, 27 Oct 2004 14:02:48 +0900
Message-ID: <003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb> (raw)
References: <Pine.LNX.4.44.0410261557560.23730-100000@hyperion2.norchemlab.com>
<15812.1098847291@sss.pgh.pa.us>
Turbo linux 7 sems to be agreeing with Curtis,
bi: $B%V%m%C%/%G%P%$%9$KAw$i$l$?%V%m%C%/(B (blocks/s)$B!#(B
bo: $B%V%m%C%/%G%P%$%9$+$i<u$1<h$C$?%V%m%C%/(B (blocks/s)$B!#(B
Sorry it's in Japanese but bi says "blocks sent to block device" and bo is
"blocks received from block device".
I don't know that much about it but the actual output seems to suggest that
the man page is wrong. I find it just the slightest bit amusing that such
errors in the docs should be translated faithfully when translating
invariably introduces errors of it's own ;)
Regards
Iain
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Curtis Zinzilieta" <curtisz@norchemlab.com>
Cc: "Anjan Dave" <adave@vantage.com>; "Matt Clark" <matt@ymogen.net>; "Rod
Taylor" <pg@rbt.ca>; "Postgresql Performance"
<pgsql-performance@postgresql.org>
Sent: Wednesday, October 27, 2004 12:21 PM
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs
> Curtis Zinzilieta <curtisz@norchemlab.com> writes:
>> On Tue, 26 Oct 2004, Tom Lane wrote:
>>> Er ... it *is* the other way around. bi is blocks in (to the CPU),
>>> bo is blocks out (from the CPU).
>
>> Ummm.....
>> [curtisz@labsoft T2]$ man vmstat
>> bi: Blocks sent to a block device (blocks/s).
>> bo: Blocks received from a block device (blocks/s).
>
> You might want to have a word with your OS vendor. My vmstat
> man page says
>
> IO
> bi: Blocks received from a block device (blocks/s).
> bo: Blocks sent to a block device (blocks/s).
>
> and certainly anyone who's been around a computer more than a week or
> two knows which direction "in" and "out" are customarily seen from.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
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: iain@mst.co.jp, curtisz@norchemlab.com, tgl@sss.pgh.pa.us, adave@vantage.com, matt@ymogen.net, pg@rbt.ca
Subject: Re: can't handle large number of INSERT/UPDATEs
In-Reply-To: <003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb>
* 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