Re: testing ProcArrayLock patches

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: testing ProcArrayLock patches
Date: 2011-11-18 19:55:34
Message-ID: 4EC663D60200002500043252@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> I think so. My take was that it was showing 32 of 64 *threads*
>> active -- the hyperthreading funkiness. Is there something in
>> particular you'd like me to check?
>
> Not really, just don't understand the number.

I'm having trouble resolving the vmstat numbers I got during the
32-client pgbench runs which modified data.

-M simple:

procs --------------memory------------- ---swap-- -----io-----
r b swpd free buff cache si so bi bo
----system---- -----cpu------
in cs us sy id wa st
30 1 4464 513492 205564572 54472124 0 0 0 78170
621724 1246300 30 8 61 1 0
27 1 4464 509288 205564572 54474600 0 0 0 125620
599403 1192046 29 8 63 1 0
35 1 4464 508368 205564572 54476996 0 0 0 89801
595939 1186496 29 8 63 0 0
25 0 4464 506088 205564572 54478668 0 0 0 90121
594800 1189649 28 8 63 0 0

-M prepared:

procs --------------memory-------------- ---swap-- -----io-----
r b swpd free buff cache si so bi bo
----system---- -----cpu------
in cs us sy id wa st
28 0 5612 1204404 205107344 54230536 0 0 0 93212
527284 1456417 22 9 69 0 0
8 1 5612 1202044 205107344 54233336 0 0 0 93217
512819 1417457 21 9 70 1 0
17 1 5612 1201892 205107344 54236048 0 0 0 132699
502333 1412878 21 9 70 0 0
19 1 5612 1199208 205107344 54238936 0 0 0 93612
519113 1484386 21 9 69 0 0

So 60% or 70% idle without any I/O wait time. I don't know how to
explain that.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2011-11-18 20:02:44 Re: testing ProcArrayLock patches
Previous Message Tom Lane 2011-11-18 19:47:46 Re: range_adjacent and discrete ranges