Skip site navigation (1) Skip section navigation (2)

Re: can't handle large number of INSERT/UPDATEs

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "Curtis Zinzilieta" <curtisz(at)norchemlab(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Anjan Dave" <adave(at)vantage(dot)com>, "Matt Clark" <matt(at)ymogen(dot)net>,"Rod Taylor" <pg(at)rbt(dot)ca>,"Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: 2004-10-27 05:02:48
Message-ID: 003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Curtis Zinzilieta" <curtisz(at)norchemlab(dot)com>
Cc: "Anjan Dave" <adave(at)vantage(dot)com>; "Matt Clark" <matt(at)ymogen(dot)net>; "Rod 
Taylor" <pg(at)rbt(dot)ca>; "Postgresql Performance" 
<pgsql-performance(at)postgresql(dot)org>
Sent: Wednesday, October 27, 2004 12:21 PM
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs


> Curtis Zinzilieta <curtisz(at)norchemlab(dot)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(at)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 


In response to

pgsql-performance by date

Next:From: Matt ClarkDate: 2004-10-27 06:09:21
Subject: Re: can't handle large number of INSERT/UPDATEs
Previous:From: John MeinelDate: 2004-10-27 04:18:09
Subject: Re: can't handle large number of INSERT/UPDATEs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group