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

From Matt Clark
Subject Re: can't handle large number of INSERT/UPDATEs
Date
Msg-id 417F3B91.9080002@ymogen.net
Whole thread Raw
In response to Re: can't handle large number of INSERT/UPDATEs  (John Meinel <john@johnmeinel.com>)
Responses Re: can't handle large number of INSERT/UPDATEs
List pgsql-performance
>> 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
>>
>
Apparently not whoever wrote the man page that everyone copied ;-)

> 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.
>
Looks like the man pages are wrong, for RH7.3 at least.  It says bi is
'blocks written', but an actual test like 'dd if=/dev/zero of=/tmp/test
bs=1024 count=16384' on an otherwise nearly idle RH7.3 box gives:
   procs                      memory    swap          io
system         cpu
 r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us
sy  id
0  0  0  75936 474704 230452 953580   0   0     0     0  106  2527   0
0  99
 0  0  0  75936 474704 230452 953580   0   0     0 16512  376  2572
0   2  98
 0  0  0  75936 474704 230452 953580   0   0     0     0  105  2537
0   0 100

Which is in line with bo being 'blocks written'.

M

pgsql-performance by date:

Previous
From: "Iain"
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Free PostgreSQL Training, Philadelphia, Oct 30