X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 46AB43A4593 for ; Wed, 27 Oct 2004 06:03:12 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84634-09 for ; Wed, 27 Oct 2004 05:03:02 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id 21BC33A458D for ; Wed, 27 Oct 2004 06:03:01 +0100 (BST) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id i9R52Pq30474; Wed, 27 Oct 2004 14:02:25 +0900 Message-ID: <003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb> From: "Iain" To: "Curtis Zinzilieta" , "Tom Lane" Cc: "Anjan Dave" , "Matt Clark" , "Rod Taylor" , "Postgresql Performance" References: <15812.1098847291@sss.pgh.pa.us> Subject: Re: can't handle large number of INSERT/UPDATEs Date: Wed, 27 Oct 2004 14:02:48 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-2022-jp"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/453 X-Sequence-Number: 8929 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" To: "Curtis Zinzilieta" Cc: "Anjan Dave" ; "Matt Clark" ; "Rod Taylor" ; "Postgresql Performance" Sent: Wednesday, October 27, 2004 12:21 PM Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs > Curtis Zinzilieta 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