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 A14BD3A3D49 for ; Wed, 27 Oct 2004 04:21:38 +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 55937-10 for ; Wed, 27 Oct 2004 03:21:33 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 570293A3BA3 for ; Wed, 27 Oct 2004 04:21:32 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9R3LVs4015813; Tue, 26 Oct 2004 23:21:31 -0400 (EDT) To: Curtis Zinzilieta Cc: Anjan Dave , Matt Clark , Rod Taylor , Postgresql Performance Subject: Re: can't handle large number of INSERT/UPDATEs In-reply-to: References: Comments: In-reply-to Curtis Zinzilieta message dated "Tue, 26 Oct 2004 16:04:35 -0700" Date: Tue, 26 Oct 2004 23:21:31 -0400 Message-ID: <15812.1098847291@sss.pgh.pa.us> From: Tom Lane 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/451 X-Sequence-Number: 8927 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