vacuum_bench_report_v11.log

text/x-log

Filename: vacuum_bench_report_v11.log
Type: text/x-log
Part: 3
Message: Re: Vacuum: allow usage of more than 1GB of work mem
 ---
  100 ---
    1: CPU: user: 3.02 s, system: 1.51 s, elapsed: 16.43 s.
       read 0.01 GB 	 write 7.34 GB
    2: CPU: user: 3.10 s, system: 1.43 s, elapsed: 16.69 s.
       read 0.00 GB 	 write 8.16 GB
    3: CPU: user: 3.04 s, system: 1.50 s, elapsed: 16.84 s.
       read 0.00 GB 	 write 8.35 GB
    4: CPU: user: 3.05 s, system: 1.47 s, elapsed: 16.60 s.
       read 0.00 GB 	 write 9.00 GB
    5: CPU: user: 3.23 s, system: 1.63 s, elapsed: 18.81 s.
       read 0.00 GB 	 write 8.67 GB
  400 ---
    1: CPU: user: 15.73 s, system: 7.18 s, elapsed: 138.46 s.
       read 3.63 GB 	 write 40.92 GB
    2: CPU: user: 14.99 s, system: 7.46 s, elapsed: 140.54 s.
       read 2.87 GB 	 write 39.55 GB
    3: CPU: user: 15.31 s, system: 7.18 s, elapsed: 140.75 s.
       read 3.94 GB 	 write 41.09 GB
    4: CPU: user: 14.65 s, system: 7.54 s, elapsed: 141.65 s.
       read 3.61 GB 	 write 40.83 GB
    5: CPU: user: 15.10 s, system: 6.80 s, elapsed: 129.74 s.
       read 3.53 GB 	 write 41.42 GB
  4000 ---
    1: CPU: user: 212.99 s, system: 116.59 s, elapsed: 3036.80 s.
       read 311.70 GB 	 write 412.05 GB
    2: CPU: user: 213.80 s, system: 115.84 s, elapsed: 3049.38 s.
       read 312.29 GB 	 write 412.02 GB
    3: CPU: user: 211.90 s, system: 116.36 s, elapsed: 3119.78 s.
       read 311.74 GB 	 write 412.26 GB
    4: CPU: user: 213.78 s, system: 115.06 s, elapsed: 3079.19 s.
       read 313.10 GB 	 write 412.26 GB
    5: CPU: user: 212.81 s, system: 116.08 s, elapsed: 3067.43 s.
       read 312.54 GB 	 write 412.20 GB
.p20 ---
  100 ---
    1: CPU: user: 4.32 s, system: 2.02 s, elapsed: 34.06 s.
       read 0.01 GB 	 write 6.58 GB
    2: CPU: user: 4.30 s, system: 1.96 s, elapsed: 34.82 s.
       read 0.00 GB 	 write 7.56 GB
    3: CPU: user: 4.35 s, system: 2.01 s, elapsed: 35.20 s.
       read 0.00 GB 	 write 7.80 GB
    4: CPU: user: 4.43 s, system: 1.93 s, elapsed: 35.45 s.
       read 0.00 GB 	 write 7.90 GB
    5: CPU: user: 4.34 s, system: 2.24 s, elapsed: 41.31 s.
       read 0.00 GB 	 write 12.67 GB
  400 ---
    1: CPU: user: 18.11 s, system: 9.09 s, elapsed: 178.91 s.
       read 2.03 GB 	 write 42.29 GB
    2: CPU: user: 18.91 s, system: 9.07 s, elapsed: 197.76 s.
       read 2.19 GB 	 write 46.88 GB
    3: CPU: user: 18.44 s, system: 8.65 s, elapsed: 195.41 s.
       read 2.08 GB 	 write 42.15 GB
    4: CPU: user: 18.92 s, system: 9.50 s, elapsed: 222.94 s.
       read 2.65 GB 	 write 44.94 GB
    5: CPU: user: 18.34 s, system: 8.49 s, elapsed: 186.65 s.
       read 2.12 GB 	 write 42.59 GB
  4000 ---
    1: CPU: user: 249.24 s, system: 136.61 s, elapsed: 3702.51 s.
       read 266.35 GB 	 write 466.48 GB
    2: CPU: user: 252.25 s, system: 135.23 s, elapsed: 3702.03 s.
       read 265.46 GB 	 write 466.43 GB
    3: CPU: user: 252.69 s, system: 135.46 s, elapsed: 3731.87 s.
       read 265.73 GB 	 write 466.31 GB
    4: CPU: user: 251.35 s, system: 134.37 s, elapsed: 3739.88 s.
       read 266.39 GB 	 write 466.72 GB
    5: CPU: user: 248.57 s, system: 135.28 s, elapsed: 3726.07 s.
       read 266.50 GB 	 write 467.13 GB
.p80 ---
  100 ---
    1: CPU: user: 3.12 s, system: 1.55 s, elapsed: 16.06 s.
       read 0.02 GB 	 write 6.75 GB
    2: CPU: user: 3.30 s, system: 1.44 s, elapsed: 18.41 s.
       read 0.00 GB 	 write 7.77 GB
    3: CPU: user: 3.37 s, system: 1.53 s, elapsed: 18.52 s.
       read 0.00 GB 	 write 8.27 GB
    4: CPU: user: 3.21 s, system: 1.48 s, elapsed: 17.40 s.
       read 0.00 GB 	 write 8.64 GB
    5: CPU: user: 3.22 s, system: 1.53 s, elapsed: 18.24 s.
       read 0.00 GB 	 write 8.83 GB
  400 ---
    1: CPU: user: 16.61 s, system: 7.74 s, elapsed: 162.07 s.
       read 4.89 GB 	 write 41.51 GB
    2: CPU: user: 16.24 s, system: 7.59 s, elapsed: 159.17 s.
       read 3.58 GB 	 write 40.16 GB
    3: CPU: user: 16.37 s, system: 7.30 s, elapsed: 149.54 s.
       read 4.03 GB 	 write 41.64 GB
    4: CPU: user: 16.29 s, system: 7.67 s, elapsed: 165.92 s.
       read 5.14 GB 	 write 43.30 GB
    5: CPU: user: 16.71 s, system: 7.36 s, elapsed: 149.73 s.
       read 3.87 GB 	 write 41.39 GB
  4000 ---
    1: CPU: user: 217.71 s, system: 119.09 s, elapsed: 3173.08 s.
       read 266.14 GB 	 write 417.20 GB
    2: CPU: user: 211.10 s, system: 118.36 s, elapsed: 3092.36 s.
       read 266.50 GB 	 write 417.39 GB
    3: CPU: user: 214.95 s, system: 119.07 s, elapsed: 3086.05 s.
       read 266.03 GB 	 write 416.85 GB
    4: CPU: user: 214.45 s, system: 119.11 s, elapsed: 3100.88 s.
       read 266.21 GB 	 write 417.10 GB
    5: CPU: user: 212.77 s, system: 118.89 s, elapsed: 3079.57 s.
       read 266.59 GB 	 write 417.58 GB
.shuf ---
  100 ---
    1: CPU: user: 6.30 s, system: 1.47 s, elapsed: 16.66 s.
       read 0.01 GB 	 write 7.68 GB
    2: CPU: user: 6.32 s, system: 1.34 s, elapsed: 16.10 s.
       read 0.00 GB 	 write 8.42 GB
    3: CPU: user: 6.38 s, system: 1.25 s, elapsed: 16.05 s.
       read 0.00 GB 	 write 8.80 GB
    4: CPU: user: 6.35 s, system: 1.30 s, elapsed: 16.70 s.
       read 0.00 GB 	 write 8.89 GB
    5: CPU: user: 6.35 s, system: 1.25 s, elapsed: 16.67 s.
       read 0.00 GB 	 write 9.18 GB
  400 ---
    1: CPU: user: 42.71 s, system: 6.49 s, elapsed: 134.71 s.
       read 5.95 GB 	 write 41.94 GB
    2: CPU: user: 46.12 s, system: 6.49 s, elapsed: 151.38 s.
       read 6.91 GB 	 write 43.59 GB
    3: CPU: user: 45.76 s, system: 6.35 s, elapsed: 143.74 s.
       read 6.29 GB 	 write 42.25 GB
    4: CPU: user: 44.01 s, system: 6.61 s, elapsed: 143.29 s.
       read 6.32 GB 	 write 42.52 GB
    5: CPU: user: 45.09 s, system: 6.55 s, elapsed: 150.33 s.
       read 5.80 GB 	 write 40.98 GB
  4000 ---
    1: CPU: user: 636.58 s, system: 102.85 s, elapsed: 3803.37 s.
       read 368.22 GB 	 write 434.75 GB
    2: CPU: user: 638.22 s, system: 100.67 s, elapsed: 3793.90 s.
       read 369.18 GB 	 write 434.92 GB
    3: CPU: user: 629.60 s, system: 102.66 s, elapsed: 3799.01 s.
       read 370.04 GB 	 write 434.87 GB
    4: CPU: user: 630.65 s, system: 103.04 s, elapsed: 3787.59 s.
       read 369.06 GB 	 write 434.92 GB
    5: CPU: user: 631.33 s, system: 100.35 s, elapsed: 3781.10 s.
       read 369.02 GB 	 write 434.97 GB
.shufp20 ---
  100 ---
    1: CPU: user: 6.79 s, system: 1.90 s, elapsed: 40.96 s.
       read 0.01 GB 	 write 11.64 GB
    2: CPU: user: 6.65 s, system: 1.99 s, elapsed: 37.75 s.
       read 0.00 GB 	 write 11.82 GB
    3: CPU: user: 6.65 s, system: 2.06 s, elapsed: 39.56 s.
       read 0.00 GB 	 write 12.01 GB
    4: CPU: user: 6.77 s, system: 1.99 s, elapsed: 38.34 s.
       read 0.00 GB 	 write 12.20 GB
    5: CPU: user: 6.90 s, system: 2.09 s, elapsed: 43.22 s.
       read 0.00 GB 	 write 11.81 GB
  400 ---
    1: CPU: user: 32.17 s, system: 8.10 s, elapsed: 195.83 s.
       read 5.38 GB 	 write 49.01 GB
    2: CPU: user: 32.28 s, system: 7.58 s, elapsed: 184.95 s.
       read 5.02 GB 	 write 44.39 GB
    3: CPU: user: 32.11 s, system: 8.80 s, elapsed: 205.88 s.
       read 5.09 GB 	 write 47.20 GB
    4: CPU: user: 33.12 s, system: 8.23 s, elapsed: 184.82 s.
       read 5.27 GB 	 write 50.44 GB
    5: CPU: user: 32.03 s, system: 8.02 s, elapsed: 205.37 s.
       read 5.61 GB 	 write 46.70 GB
  4000 ---
    1: CPU: user: 599.59 s, system: 117.45 s, elapsed: 3923.08 s.
       read 322.31 GB 	 write 489.32 GB
    2: CPU: user: 618.21 s, system: 119.65 s, elapsed: 3905.59 s.
       read 322.58 GB 	 write 489.50 GB
    3: CPU: user: 596.41 s, system: 121.37 s, elapsed: 3963.01 s.
       read 323.10 GB 	 write 490.14 GB
    4: CPU: user: 592.31 s, system: 120.62 s, elapsed: 3900.14 s.
       read 322.37 GB 	 write 489.02 GB
    5: CPU: user: 593.01 s, system: 121.60 s, elapsed: 3919.52 s.
       read 322.82 GB 	 write 489.81 GB
.shufp80 ---
  100 ---
    1: CPU: user: 6.12 s, system: 1.50 s, elapsed: 17.19 s.
       read 0.01 GB 	 write 7.83 GB
    2: CPU: user: 6.15 s, system: 1.54 s, elapsed: 16.70 s.
       read 0.00 GB 	 write 8.32 GB
    3: CPU: user: 6.41 s, system: 1.47 s, elapsed: 17.76 s.
       read 0.00 GB 	 write 8.65 GB
    4: CPU: user: 6.22 s, system: 1.54 s, elapsed: 18.75 s.
       read 0.00 GB 	 write 8.87 GB
    5: CPU: user: 6.35 s, system: 1.39 s, elapsed: 17.32 s.
       read 0.00 GB 	 write 8.92 GB
  400 ---
    1: CPU: user: 49.19 s, system: 7.19 s, elapsed: 170.54 s.
       read 5.85 GB 	 write 41.30 GB
    2: CPU: user: 46.73 s, system: 7.36 s, elapsed: 166.94 s.
       read 7.30 GB 	 write 44.05 GB
    3: CPU: user: 50.87 s, system: 6.81 s, elapsed: 178.15 s.
       read 7.71 GB 	 write 44.49 GB
    4: CPU: user: 49.49 s, system: 7.49 s, elapsed: 171.60 s.
       read 6.10 GB 	 write 42.17 GB
    5: CPU: user: 49.87 s, system: 7.12 s, elapsed: 174.80 s.
       read 6.95 GB 	 write 43.72 GB
  4000 ---
    1: CPU: user: 586.36 s, system: 104.70 s, elapsed: 3676.99 s.
       read 323.34 GB 	 write 441.03 GB
    2: CPU: user: 589.21 s, system: 104.50 s, elapsed: 3675.68 s.
       read 322.97 GB 	 write 439.58 GB
    3: CPU: user: 585.58 s, system: 106.73 s, elapsed: 3722.73 s.
       read 323.28 GB 	 write 440.71 GB
    4: CPU: user: 585.14 s, system: 106.00 s, elapsed: 3676.84 s.
       read 323.62 GB 	 write 441.79 GB
    5: CPU: user: 588.80 s, system: 106.25 s, elapsed: 3693.14 s.
       read 322.60 GB 	 write 439.38 GB