Re: can't handle large number of INSERT/UPDATEs - Mailing list pgsql-performance

From Iain
Subject Re: can't handle large number of INSERT/UPDATEs
Date
Msg-id 003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to Re: can't handle large number of INSERT/UPDATEs  (Curtis Zinzilieta <curtisz@norchemlab.com>)
List pgsql-performance
Turbo linux 7 sems to be agreeing with Curtis,

bi: ブロックデバイスに送られたブロック (blocks/s)。
bo: ブロックデバイスから受け取ったブロック (blocks/s)。

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


pgsql-performance by date:

Previous
From: John Meinel
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: Matt Clark
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs