pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 




view thread (24+ messages)  latest in thread

Message-ID: <003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb>
Permalink:  ../003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb/
Also on:    postgresql.org/message-id/003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb

 · 

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