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

From Tom Lane
Subject Re: can't handle large number of INSERT/UPDATEs
Date
Msg-id 15812.1098847291@sss.pgh.pa.us
Whole thread Raw
In response to Re: can't handle large number of INSERT/UPDATEs  (Curtis Zinzilieta <curtisz@norchemlab.com>)
Responses Re: can't handle large number of INSERT/UPDATEs
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: John Meinel
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs