stat-patch.txt

text/plain

Filename: stat-patch.txt
Type: text/plain
Part: 1
Message: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue
joel@Mac pg_async_notify_test % ./pg_async_notify_test --listeners 1 --notifiers 1 --channels 1
10 s: 880520 sent (89409/s), 880519 received (89408/s)
 0.00-0.01ms     #          17 (0.0%) avg: 0.008ms
 0.01-0.10ms     #########  880350 (100.0%) avg: 0.015ms
 0.10-1.00ms     #          150 (0.0%) avg: 0.169ms
 1.00-10.00ms    #          2 (0.0%) avg: 1.427ms
 10.00-100.00ms             0 (0.0%) avg: 0.000ms
>100.00ms                  0 (0.0%) avg: 0.000ms
^C
joel@Mac pg_async_notify_test % ./pg_async_notify_test --listeners 2 --notifiers 2 --channels 2
10 s: 744302 sent (74199/s), 1488608 received (148402/s)
 0.00-0.01ms     #          12 (0.0%) avg: 0.009ms
 0.01-0.10ms     #########  1470763 (98.8%) avg: 0.045ms
 0.10-1.00ms     #          17293 (1.2%) avg: 0.116ms
 1.00-10.00ms    #          540 (0.0%) avg: 1.447ms
 10.00-100.00ms             0 (0.0%) avg: 0.000ms
>100.00ms                  0 (0.0%) avg: 0.000ms
^C
joel@Mac pg_async_notify_test % ./pg_async_notify_test --listeners 4 --notifiers 4 --channels 4
10 s: 302339 sent (32417/s), 1209366 received (129677/s)
 0.00-0.01ms                0 (0.0%) avg: 0.000ms
 0.01-0.10ms     #          58 (0.0%) avg: 0.072ms
 0.10-1.00ms     #########  1202143 (99.4%) avg: 0.432ms
 1.00-10.00ms    #          7165 (0.6%) avg: 1.492ms
 10.00-100.00ms             0 (0.0%) avg: 0.000ms
>100.00ms                  0 (0.0%) avg: 0.000ms
^C
joel@Mac pg_async_notify_test % ./pg_async_notify_test --listeners 8 --notifiers 8 --channels 8
10 s: 94129 sent (9464/s), 753090 received (75715/s)
 0.00-0.01ms                0 (0.0%) avg: 0.000ms
 0.01-0.10ms                0 (0.0%) avg: 0.000ms
 0.10-1.00ms                0 (0.0%) avg: 0.000ms
 1.00-10.00ms    #########  714160 (94.8%) avg: 6.382ms
 10.00-100.00ms  #          38757 (5.1%) avg: 19.804ms
>100.00ms       #          173 (0.0%) avg: 105.323ms
^C
joel@Mac pg_async_notify_test % ./pg_async_notify_test --listeners 16 --notifiers 16 --channels 16
10 s: 24874 sent (2547/s), 398031 received (40618/s)
 0.00-0.01ms                0 (0.0%) avg: 0.000ms
 0.01-0.10ms                0 (0.0%) avg: 0.000ms
 0.10-1.00ms                0 (0.0%) avg: 0.000ms
 1.00-10.00ms    #          30 (0.0%) avg: 6.204ms
 10.00-100.00ms  ####       197439 (49.6%) avg: 93.703ms
>100.00ms       #####      200564 (50.4%) avg: 106.259ms
^C
joel@Mac pg_async_notify_test %