Re: testing ProcArrayLock patches
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>
Cc: <pgsql-hackers@postgresql.org>
Date: 2011-11-18T19:55:34Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Don't elide blank lines when accumulating psql command history.
- ff4fd4bf53c5 9.2.0 cited
Robert Haas <robertmhaas@gmail.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