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 40D683A458E for ; Wed, 27 Oct 2004 05:18:31 +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 74517-07 for ; Wed, 27 Oct 2004 04:18:25 +0000 (GMT) Received: from ct.radiology.uiowa.edu (ct.radiology.uiowa.edu [129.255.60.186]) by svr1.postgresql.org (Postfix) with ESMTP id CA89A3A4583 for ; Wed, 27 Oct 2004 05:18:24 +0100 (BST) Received: from [192.168.1.11] (12-217-241-0.client.mchsi.com [12.217.241.0]) by ct.radiology.uiowa.edu (8.11.6/8.11.6) with ESMTP id i9R4IF324293; Tue, 26 Oct 2004 23:18:15 -0500 Message-ID: <417F2181.4000801@johnmeinel.com> Date: Tue, 26 Oct 2004 23:18:09 -0500 From: John Meinel User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Curtis Zinzilieta , Anjan Dave , Matt Clark , Rod Taylor , Postgresql Performance Subject: Re: can't handle large number of INSERT/UPDATEs References: <15812.1098847291@sss.pgh.pa.us> In-Reply-To: <15812.1098847291@sss.pgh.pa.us> X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig8A306CDFFF6456D3531A6069" 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/452 X-Sequence-Number: 8928 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig8A306CDFFF6456D3531A6069 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Tom Lane wrote: > 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 > Interesting. I checked this on several machines. They actually say different things. Redhat 9- bi: Blocks sent to a block device (blocks/s). Latest Cygwin- bi: Blocks sent to a block device (blocks/s). Redhat 7.x- bi: Blocks sent to a block device (blocks/s). Redhat AS3- bi: blocks sent out to a block device (in blocks/s) I would say that I probably agree, things should be relative to the cpu. However, it doesn't seem to be something that was universally agreed upon. Or maybe the man-pages were all wrong, and only got updated recently. John =:-> --------------enig8A306CDFFF6456D3531A6069 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBfyGBJdeBCYSNAAMRAvI1AJ4i1AzY5iwlsQXVpUy6oUw1+jd/kACguWgx 67UY50j8yjXcHoSo6vdXGrE= =VNsc -----END PGP SIGNATURE----- --------------enig8A306CDFFF6456D3531A6069--