wiki:DC2ChunkPerf/LoadAndIndex
Last modified 12 years ago Last modified on 05/03/2007 02:49:23 AM

Coarse chunks - load and index performance

Performance numbers for loading from coarse chunk partitions with no indexes into an in-memory table with two pre-existing indexes: a hash index on id and a B-tree index on (zoneId, ra).

High Density FOV

Skinny Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :

real    1m0.011s                                    real   0m58.389s
user    0m0.019s                                    user    0m0.019s
sys     0m0.016s                                    sys     0m0.016s

 r/s     kr/s   actv  svc_t  %w  %b                 r/s    kr/s   actv  svc_t  %w  %b
32.7  19963.1    0.5   14.4   0  37                 0.0     0.0    0.0    0.0   0   0
10.0  10241.4    0.2   17.4   0  17                 0.0     0.0    0.0    0.0   0   0
13.0  11264.2    0.2   15.8   0  20                 0.0     0.0    0.0    0.0   0   0
11.0  10240.0    0.2   15.9   0  18                 0.0     0.0    0.0    0.0   0   0
18.0  10010.8    0.3   14.8   0  21                 0.0     0.0    0.0    0.0   0   0
10.0  10240.0    0.2   18.6   0  19                 0.0     0.0    0.0    0.0   0   0
12.0  11264.1    0.2   15.5   0  19                 0.0     0.0    0.0    0.0   0   0
13.0  11263.2    0.2   14.9   0  19                 0.0     0.0    0.1   10.8   0   2
10.0  10240.2    0.2   16.8   0  17                 0.0     0.0    0.0    0.0   0   0
12.0  10240.1    0.2   16.8   0  19                 0.0     0.0    0.0    0.0   0   0
11.0  10240.2    0.2   16.5   0  18                 0.0     0.0    0.0    0.0   0   0
17.0   9195.2    0.2   14.3   0  20                 0.0     0.0    0.0    0.0   0   0
24.0  22987.6    0.4   16.7   0  39                 0.0     0.0    0.0    0.0   0   0
62.0  46746.7    1.0   15.6   0  83                 0.0     0.0    0.0    0.0   0   0
18.0  17408.3    0.3   16.2   0  29                 0.0     0.0    0.0    0.0   0   0
 6.0   5359.8    0.1   14.7   0   9                 0.0     0.0    0.0    0.0   0   0
 5.0   5120.1    0.1   17.3   0   9                 0.0     0.0    0.0    0.0   0   0
 6.0   5888.1    0.1   16.2   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5119.9    0.1   20.0   0  10                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.0    0.1   15.1   0   9                 0.0     0.0    0.0    0.0   0   0
 6.0   4864.0    0.1   14.9   0   9                 0.0     0.0    0.0    0.0   0   0
15.0   5226.9    0.3   17.8   0  15                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.2    0.1   14.5   0  10                 0.0     0.0    0.0    0.8   0   0
 6.0   5119.9    0.1   14.7   0   9                 0.0     0.0    0.0    0.0   0   0
 5.0   5119.9    0.1   18.0   0   9                 0.0     0.0    0.0    0.0   0   0
 6.0   5984.2    0.1   16.0   0  10                 0.0     0.0    0.0    0.0   0   0
 6.0   5279.6    0.1   15.3   0   9                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.4    0.1   16.8   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5120.0    0.1   18.0   0   9                 0.0     0.0    0.0    0.0   0   0
 6.0   5119.5    0.1   16.8   0  10                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.7    0.1   16.5   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5120.1    0.1   15.8   0   8                 0.0     0.0    0.0    0.0   0   0
 6.0   5119.9    0.1   14.9   0   9                 0.0     0.0    0.2   11.7   0   2
 6.0   6144.1    0.1   17.5   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5119.9    0.1   16.4   0   8                 0.0     0.0    0.0    0.0   0   0
 6.0   5120.1    0.1   14.6   0   9                 0.0     0.0    0.0    0.0   0   0
 5.0   4944.0    0.1   16.3   0   8                 0.0     0.0    0.0    0.0   0   0
15.0   5226.9    0.2   13.3   0  14                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.0    0.1   16.8   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   4344.0    0.1   15.3   0   8                 0.0     0.0    0.0    0.0   0   0
 6.0   5895.7    0.1   16.5   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5120.3    0.1   16.3   0   8                 0.0     0.0    0.0    0.0   0   0
 6.0   6144.0    0.1   16.4   0  10                 0.0     0.0    0.0    0.0   0   0
 5.0   5120.0    0.1   17.4   0   9                 0.0     0.0    0.0    0.0   0   0
24.0  24575.9    0.4   16.9   0  40                 0.0     0.0    0.0    0.0   0   0
40.0  33891.0    0.8   21.0   0  74                 0.0     0.0    0.0    0.0   0   0
 9.0   9216.1    0.1   15.4   0  14                 0.0     0.0    0.0    0.0   0   0
14.0   7890.7    0.2   14.5   0  17                 0.0     0.0    0.0    0.0   0   0
 9.0   9216.3    0.1   16.6   0  15                 0.0     0.0    0.0    0.0   0   0
 9.0   9191.9    0.1   16.6   0  15                 0.0     0.0    0.0    0.0   0   0
 9.0   9215.9    0.2   17.1   0  15                 0.0     0.0    0.0    0.0   0   0
10.0  10240.2    0.2   16.8   0  17                 0.0     0.0    0.0    0.0   0   0
 9.0   9215.9    0.2   16.9   0  15                 0.0     0.0    0.0    0.8   0   0
10.0  10239.8    0.2   17.9   0  18                 0.0     0.0    0.0    0.0   0   0
14.0   9011.2    0.2   16.0   0  19                 0.0     0.0    0.0    0.0   0   0
10.0   9671.9    0.2   16.9   0  17                 0.0     0.0    0.0    0.0   0   0
11.0  10808.1    0.2   16.5   0  18                 0.0     0.0    0.0    0.0   0   0
12.0  10240.0    0.2   16.3   0  19                 0.0     0.0    0.0    0.0   0   0
 9.0   9215.9    0.2   16.9   0  15                 

Fat Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :

real   5m27.291s                                    real   5m12.330s
user    0m0.019s                                    user    0m0.020s
sys     0m0.016s                                    sys     0m0.014s


 r/s     kr/s   actv  svc_t  %w  %b                  r/s     kr/s   actv  svc_t  %w  %b
76.2  61659.1    1.7   22.3   0  94                  0.0      0.0    0.0    0.0   0   0
74.0  74762.5    1.7   22.5   0 100                  0.0      0.0    0.0    0.0   0   0
54.0  55298.2    1.1   20.7   0  79                  0.0      0.0    0.0    0.9   0   0
35.0  33664.4    0.6   15.9   0  55                  0.0      0.0    0.0    0.0   0   0
34.0  31871.8    0.6   16.7   0  55                  0.0      0.0    0.0    0.0   0   0
48.0  31740.5    0.8   16.9   0  54                  0.0      0.0    0.0    0.0   0   0
72.0  30528.8    1.5   20.6   0  60                  0.0      0.0    0.0    0.0   0   0
40.0  32960.4    0.5   13.7   0  53                 17.0  16592.2    0.3   19.3   0  30
33.0  31750.7    0.5   16.4   0  53                 48.0  32768.1    0.6   13.1   0  59
34.0  33777.0    0.6   16.3   0  55                 34.0  34815.8    0.6   17.0   0  58
48.0  32770.2    0.7   13.7   0  59                 36.0  35680.0    0.6   16.3   0  59
34.0  34816.4    0.6   16.9   0  57                 35.0  33952.7    0.6   16.2   0  57
35.0  34653.0    0.6   17.4   0  60                 35.0  33271.4    0.6   16.5   0  57
33.0  31903.8    0.5   16.6   0  55                 36.0  34312.1    0.6   16.4   0  59
35.0  33272.6    0.6   15.9   0  55                 34.0  33792.3    0.6   16.9   0  57
35.0  33287.7    0.6   16.6   0  58                 35.0  34086.3    0.6   16.6   0  58
34.0  33791.7    0.5   16.2   0  55                 35.0  34520.3    0.6   16.2   0  56
35.0  34089.7    0.6   16.5   0  58                 35.0  34817.3    0.6   17.1   0  60
33.0  32472.8    0.5   16.7   0  55                 46.0  34260.3    0.9   20.0   0  64
35.0  34815.8    0.6   17.0   0  59                 39.0  33319.7    0.6   15.5   0  57
46.0  34264.5    0.8   18.1   0  61                 35.0  32771.5    0.6   17.7   0  60
40.0  34344.2    0.6   16.1   0  58                 35.0  32767.8    0.6   16.5   0  55
35.0  32764.7    0.6   16.6   0  57                 36.0  33792.7    0.6   16.3   0  58
35.0  32758.4    0.6   16.8   0  56                 39.0  33872.4    0.6   15.5   0  57
35.0  32778.1    0.6   16.4   0  57                  5.0   4823.9    0.1   15.0   0   8
38.0  32850.5    0.6   16.0   0  57                  0.0      0.0    0.0    0.0   0   0
42.0  27825.8    0.6   14.6   0  54                  0.0      0.0    0.0    0.0   0   0
35.0  32696.1    0.5   15.3   0  53                  0.0      0.0    0.0    0.0   0   0
35.0  32768.1    0.6   16.2   0  56                  0.0      0.0    0.0    0.0   0   0
37.0  34816.4    0.6   16.6   0  58                  0.0      0.0    0.0    0.0   0   0
35.0  32767.7    0.6   17.0   0  58                  0.0      0.0    0.0    0.0   0   0
39.0  33872.8    0.6   16.0   0  58                  0.0      0.0    0.0    0.0   0   0
35.0  32684.4    0.6   16.4   0  57                  0.0      0.0    0.2   13.9   0   2
35.0  32769.1    0.5   15.7   0  55                  0.0      0.0    0.0    0.0   0   0
34.0  32767.4    0.6   16.7   0  56                  0.0      0.0    0.0    0.0   0   0
34.0  32769.9    0.6   17.0   0  57                  1.0   1024.0    0.1   68.0   0   4
36.0  32784.0    0.6   15.7   0  56                 36.0  32999.9    0.6   17.2   0  58
35.0  33776.6    0.6   16.1   0  56                 35.0  34800.2    0.6   16.7   0  58
35.0  33791.9    0.6   16.3   0  57                 35.0  33788.5    0.6   17.2   0  59
35.0  33788.9    0.6   16.0   0  55                 38.0  34834.9    0.6   15.5   0  58
35.0  32768.0    0.6   18.4   0  62                 35.0  33775.9    0.6   16.6   0  58
35.0  33792.4    0.6   16.6   0  58                 35.0  33789.8    0.6   17.4   0  59
33.0  31746.3    0.6   17.1   0  55                 34.0  32769.2    0.6   17.2   0  57
35.0  33792.1    0.6   16.0   0  56                 35.0  33793.7    0.6   16.4   0  57
37.0  33808.2    0.6   16.1   0  58                 37.0  33807.7    0.6   15.7   0  57
34.0  32752.2    0.6   16.6   0  56                 35.0  33773.8    0.6   16.5   0  57
33.0  31740.4    0.6   17.8   0  56                 35.0  33790.1    0.6   16.9   0  59
34.0  32769.0    0.6   16.4   0  55                 36.0  32768.9    0.6   16.1   0  56
33.0  31742.5    0.6   17.1   0  56                 35.0  33792.1    0.6   15.8   0  55
36.0  32784.7    0.6   16.6   0  58                 35.0  33791.3    0.6   16.3   0  56
34.0  32752.4    0.6   16.5   0  56                 34.0  32769.1    0.6   16.9   0  57
34.0  32767.4    0.5   16.0   0  54                 35.0  33794.3    0.6   16.6   0  58
34.0  32771.4    0.6   17.0   0  57                 37.0  33792.9    0.6   15.5   0  56
33.9  32715.9    0.6   17.4   0  58                 35.0  33791.4    0.6   17.0   0  59
35.1  33845.7    0.6   16.2   0  58                 37.0  33808.7    0.6   16.2   0  58
36.0  32768.4    0.6   15.8   0  55                 34.0  32749.5    0.5   16.2   0  54
34.0  32767.2    0.6   16.8   0  56                 34.0  32765.7    0.6   17.2   0  58
37.0  33808.4    0.6   15.4   0  56                 34.0  32772.2    0.6   16.6   0  55
35.0  33776.4    0.6   16.3   0  57                 34.0  32768.9    0.6   16.5   0  56
35.0  33792.4    0.6   16.5   0  58                  2.0   1831.9    0.0   13.2   0   3
34.0  32767.7    0.6   17.1   0  57                  0.0      0.0    0.0    0.0   0   0
40.0  28305.3    0.6   15.3   0  56                  0.0      0.0    0.0    0.0   0   0
35.0  32776.8    0.6   16.1   0  54                  0.0      0.0    0.0    0.9   0   0
34.0  32764.8    0.5   16.0   0  54                  0.0      0.0    0.0    0.0   0   0
33.0  31472.5    0.5   16.5   0  54                  0.0      0.0    0.0    0.0   0   0
33.0  31746.5    0.6   17.3   0  57                  0.0      0.0    0.0    0.0   0   0
35.0  32767.7    0.6   16.4   0  57                 27.0  25783.2    0.6   23.9   0  37
34.0  32760.8    0.6   16.6   0  56                 75.0  69622.0    1.8   23.7   0  99
39.0  37125.6    0.7   18.4   0  63                 73.0  73758.0    1.7   22.8   0  99
70.0  67584.0    1.6   23.4   0  96                 72.0  70642.0    1.7   23.3   0  98
70.0  67585.2    1.6   23.4   0  96                 68.0  67597.7    1.7   24.8   0  99
79.0  72710.8    1.7   21.6   0  98                 75.0  74743.2    1.7   22.3   0  99
73.0  70648.4    1.7   23.4   0  99                 78.0  73724.5    1.7   21.6   0  99
73.0  72697.5    1.7   22.6   0  98                 76.0  71682.3    1.7   22.1   0  99
73.0  72711.1    1.7   22.9   0 100                 79.0  72527.5    1.7   21.9   0  99
68.0  67581.3    1.7   24.7   0  98                  3.0   2031.5    0.0   13.4   0   3
74.0  73728.3    1.7   22.4   0  99                 12.0  10427.4    0.3   25.4   0  17
76.0  71677.9    1.7   22.4   0 100                 76.0  73725.3    1.7   21.8   0  98
76.0  68617.0    1.7   22.7   0  99                 20.0  18432.3    0.3   16.1   0  32
81.0  64772.2    1.6   19.9   0  94                 19.0  19456.3    0.3   17.2   0  33
75.0  68624.2    1.7   22.2   0  99                 20.0  18432.1    0.3   16.6   0  33
78.0  69632.1    1.7   22.4   0  99                 20.0  18432.1    0.3   16.5   0  31
75.0  70656.7    1.6   21.9   0  98                 20.0  18433.3    0.3   15.9   0  31
76.0  68605.8    1.7   22.6   0  99                 18.0  18432.1    0.3   17.1   0  31
76.0  71680.1    1.7   21.6   0  99                 20.0  18432.2    0.3   15.9   0  31
72.0  69631.2    1.7   23.2   0  99                 18.0  18432.3    0.3   17.8   0  32
69.0  66564.5    1.5   21.7   0  91                 20.0  18431.4    0.3   16.4   0  33
21.0  19456.1    0.3   16.2   0  34                 20.0  18447.7    0.3   16.1   0  31
19.0  18199.8    0.3   16.8   0  32                 19.0  18680.5    0.3   16.7   0  31
21.0  18679.8    0.3   16.1   0  33                 20.0  18716.9    0.3   16.6   0  33
18.0  18414.9    0.3   17.8   0  32                 19.0  17883.1    0.3   16.5   0  31
20.0  18432.7    0.3   15.4   0  30                 19.0  18431.8    0.3   16.7   0  32
18.0  18431.5    0.3   16.8   0  30                 20.0  18431.9    0.3   16.0   0  32
20.0  18432.7    0.3   15.6   0  31                 18.0  18431.6    0.3   18.0   0  32
18.0  18431.3    0.3   16.9   0  30                 20.0  18432.4    0.3   15.9   0  32
19.0  17407.9    0.3   16.1   0  30                 20.0  18447.5    0.3   15.9   0  31
20.0  18448.1    0.3   14.8   0  29                 18.0  18415.9    0.3   17.5   0  31
19.0  17671.7    0.3   16.8   0  31                 20.0  18432.2    0.3   15.8   0  31
18.0  18152.0    0.3   18.1   0  33                 20.0  18432.2    0.3   15.6   0  31
20.0  18432.3    0.3   15.4   0  31                 18.0  18431.9    0.3   17.1   0  31
19.0  18432.2    0.3   16.7   0  32                 20.0  18432.6    0.3   16.1   0  32
19.0  17407.9    0.3   16.5   0  31                 20.0  18445.9    0.3   15.9   0  31
18.0  18433.4    0.3   17.6   0  32                 18.0  18417.5    0.3   17.1   0  31
20.0  18432.1    0.3   16.1   0  32                 20.0  18432.0    0.3   16.4   0  33
20.0  18448.0    0.3   15.9   0  30                 19.0  17944.2    0.3   17.1   0  32
18.0  18415.9    0.3   17.3   0  31                 19.0  18920.0    0.3   16.9   0  32
20.0  18430.0    0.3   16.2   0  32                 20.0  18431.9    0.3   15.8   0  31
19.0  17408.4    0.3   16.6   0  31                 20.0  18447.5    0.3   17.3   0  33
18.0  18433.6    0.3   16.6   0  30                 18.0  18415.9    0.3   17.3   0  31
20.0  18430.5    0.3   15.9   0  31                 20.0  18432.4    0.3   15.2   0  30
20.0  18447.9    0.3   15.8   0  31                 18.0  18432.2    0.3   17.3   0  31
18.0  18415.8    0.3   17.1   0  31                 20.0  18427.2    0.3   16.0   0  32
19.0  17408.3    0.3   16.5   0  31                 18.0  17972.7    0.3   16.6   0  30
17.9  18368.5    0.3   17.3   0  31                  6.0   5400.0    0.1   15.8   0   9
20.1  18497.4    0.3   16.4   0  33                  0.0      0.0    0.0    0.0   0   0
19.0  18199.9    0.3   16.9   0  32                  0.0      0.0    0.0    0.0   0   0
21.0  18680.3    0.3   15.4   0  32                  0.0      0.0    0.0    0.0   0   0
18.0  18415.8    0.3   18.5   0  33                  0.0      0.0    0.0    0.0   0   0
20.0  18431.7    0.3   14.9   0  30                  0.0      0.0    0.0    0.0   0   0
18.0  18432.4    0.3   17.0   0  30                  0.0      0.0    0.0    0.0   0   0
20.0  18432.0    0.3   16.6   0  33                  0.0      0.0    0.0    0.0   0   0
18.0  18432.1    0.3   17.3   0  31                  0.0      0.0    0.0    0.0   0   0
30.0  16321.9    0.5   15.9   0  38                  0.0      0.0    0.0    1.1   0   0
17.0  17392.2    0.3   17.2   0  29                  0.0      0.0    0.0    0.0   0   0
20.0  18431.8    0.3   15.3   0  30                  0.0      0.0    0.0    0.0   0   0
18.0  18432.0    0.3   18.2   0  33                  0.0      0.0    0.0    0.0   0   0
20.0  17959.9    0.3   15.3   0  30                  0.0      0.0    0.0    0.0   0   0
18.0  17880.2    0.3   17.6   0  32                  0.0      0.0    0.0    0.0   0   0
20.0  18432.0    0.3   15.9   0  32                  0.0      0.0    0.0    0.0   0   0
22.0  18432.0    0.3   15.0   0  32                  0.0      0.0    0.0    0.0   0   0
18.0  18413.8    0.3   16.8   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17410.0    0.3   15.6   0  29                  0.0      0.0    0.0    0.0   0   0
18.0  18430.4    0.3   16.4   0  29                  0.0      0.0    0.0    1.1   0   0
20.0  18432.1    0.3   16.3   0  32                  0.0      0.0    0.0    0.0   0   0
17.0  17408.4    0.3   17.5   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17408.5    0.3   15.5   0  29                 13.0  12472.1    0.2   18.3   0  21
18.0  18431.6    0.3   17.3   0  31                 19.0  18431.9    0.3   16.2   0  31
17.0  17408.4    0.3   17.6   0  30                 18.0  18177.8    0.3   17.4   0  31
19.0  18431.8    0.3   16.8   0  32                 18.0  17663.9    0.3   17.1   0  31
19.0  18432.8    0.3   15.9   0  30                 18.0  18432.2    0.3   17.0   0  31
17.0  17407.3    0.3   17.3   0  29                 18.0  18430.1    0.3   17.5   0  31
19.0  18432.9    0.3   16.6   0  32                 19.0  18432.4    0.3   16.8   0  32
18.0  18430.1    0.3   17.9   0  32                 18.0  17919.6    0.3   17.2   0  31
17.0  17408.6    0.3   17.9   0  32                 18.0  17921.6    0.3   17.9   0  32
19.0  18433.0    0.3   16.0   0  30                 19.0  18432.1    0.3   16.5   0  31
17.0  17407.8    0.3   17.1   0  29                 21.0  18512.1    0.3   16.2   0  33
19.0  18432.3    0.3   16.5   0  31                 18.0  18352.1    0.3   17.0   0  31
19.0  18431.9    0.3   16.0   0  30                 21.0  18431.8    0.3   15.8   0  33
18.0  18432.1    0.3   17.4   0  31                 19.0  18776.0    0.3   16.6   0  31
18.0  18432.1    0.3   17.1   0  31                 19.0  18088.1    0.3   16.1   0  31
19.0  18431.5    0.3   16.6   0  32                 19.0  18432.0    0.3   16.6   0  32
18.0  18432.6    0.3   16.5   0  30                 20.0  17406.5    0.3   16.3   0  32
18.0  17406.3    0.3   17.3   0  31                 21.0  18431.2    0.3   14.3   0  31
18.0  18433.0    0.3   17.0   0  30                 21.0  18512.5    0.3   15.7   0  32
18.0  17407.2    0.3   16.8   0  30                 17.0  17327.9    0.3   16.7   0  28
21.0  18512.1    0.3   14.5   0  29                 21.0  18432.3    0.3   14.6   0  30
17.0  17327.9    0.3   17.9   0  30                 18.0  18433.4    0.3   17.8   0  32
21.0  18433.5    0.3   16.2   0  33                 18.0  17406.5    0.3   17.6   0  32
20.0  18431.8    0.3   15.5   0  31                 21.0  18434.0    0.3   15.4   0  32
18.0  17408.3    0.3   16.7   0  30                 18.0  18431.6    0.3   17.4   0  31
21.0  18430.7    0.3   14.7   0  30                 20.0  17407.4    0.3   15.4   0  30
18.0  18433.3    0.3   17.6   0  32                 20.0  17472.5    0.3   15.2   0  29
21.0  18430.4    0.3   15.5   0  32                 21.0  18369.2    0.3   15.4   0  32
20.0  17488.3    0.3   14.7   0  28                 18.0  18431.9    0.3   17.9   0  32
18.0  18353.3    0.3   17.5   0  31                 20.0  17408.2    0.3   16.0   0  31
21.0  18432.1    0.3   15.1   0  31                 18.0  18431.8    0.3   17.3   0  31
18.0  17407.7    0.3   16.7   0  30                 21.0  18432.0    0.3   14.6   0  31
21.0  18432.4    0.3   15.6   0  32                 21.0  18497.7    0.4   17.0   0  32
18.0  18430.3    0.3   18.3   0  33                 17.0  17341.2    0.3   17.8   0  30
21.0  18433.5    0.3   15.6   0  32                 21.0  18427.0    0.3   15.7   0  33
20.0  17486.7    0.3   17.4   0  32                 18.0  17869.1    0.3   17.2   0  31
18.0  18351.8    0.3   16.7   0  30                 21.0  17550.3    0.3   16.0   0  33
20.0  17409.1    0.3   16.5   0  32                 18.0  17832.2    0.3   17.1   0  31
18.0  18431.9    0.3   17.0   0  30                 21.0  18432.8    0.3   15.4   0  32
21.0  18432.1    0.3   15.3   0  32                 18.0  17454.8    0.3   16.9   0  30
20.0  18262.5    0.3   15.5   0  31                 20.0  17376.5    0.3   16.3   0  31
21.0  17656.5    0.3   16.1   0  31                 18.0  18416.0    0.3   15.7   0  28
18.0  18352.0    0.3   16.5   0  30                 20.0  18431.8    0.3   15.6   0  31
20.0  17408.0    0.3   15.2   0  30                 17.0  17408.0    0.3   17.4   0  29
17.0  17407.7    0.3   18.9   0  32                 20.0  18432.0    0.3   16.0   0  32
20.0  18432.3    0.3   16.7   0  33                 17.0  17409.6    0.3   17.4   0  30
20.0  17408.2    0.3   15.2   0  30                 20.0  18432.2    0.3   15.8   0  31
17.0  17409.0    0.3   18.5   0  31                 19.0  17405.9    0.3   16.9   0  32
21.0  18432.2    0.3   15.3   0  32                 21.0  18767.8    0.3   14.5   0  30
19.0  18480.1    0.3   16.4   0  31                 19.0  18096.1    0.3   16.1   0  31
21.0  18399.9    0.3   14.9   0  30                 17.0  17407.9    0.3   17.6   0  30
20.0  18415.8    0.3   16.4   0  33                 20.0  18434.3    0.3   16.2   0  32
17.0  17407.8    0.3   18.1   0  31                 18.0  18431.6    0.3   17.2   0  31
20.0  18431.9    0.3   14.8   0  29                 20.0  18432.5    0.3   16.2   0  32
18.0  18432.5    0.3   17.8   0  32                 19.0  17422.2    0.3   15.9   0  29
20.0  18432.0    0.3   16.2   0  32                 18.0  18417.6    0.3   17.4   0  31
20.0  18447.9    0.3   16.0   0  31                 19.0  17408.2    0.3   17.1   0  32
17.0  17391.6    0.3   17.5   0  30                 20.0  18432.0    0.3   15.5   0  31
21.0  18768.5    0.3   15.4   0  32                 18.0  18431.6    0.3   17.1   0  31
19.0  18096.0    0.3   16.4   0  31                  3.0   2888.0    0.0   16.7   0   5
19.0  17408.2    0.3   16.8   0  31                  0.0      0.0    0.0    0.0   0   0
18.0  18432.2    0.3   17.4   0  31                  0.0      0.0    0.0    0.0   0   0
20.0  18431.9    0.3   15.9   0  32                  0.0      0.0    0.0    0.0   0   0
19.0  17423.6    0.3   17.1   0  32                  0.0      0.0    0.0    0.0   0   0
18.0  18416.3    0.3   16.1   0  29                  0.0      0.0    0.0    0.0   0   0
20.0  18431.9    0.3   16.7   0  33                  0.0      0.0    0.0    0.0   0   0
18.0  18432.0    0.3   16.7   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17406.4    0.3   15.8   0  29                  0.0      0.0    0.0    0.7   0   0
29.7  15330.6    0.5   16.0   0  36                  0.0      0.0    0.0    0.0   0   0
18.2  18620.6    0.3   15.9   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17406.7    0.3   15.2   0  29                  0.0      0.0    0.0    0.0   0   0
17.0  17409.5    0.3   17.8   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17408.0    0.3   16.2   0  31                  0.0      0.0    0.0    0.0   0   0
18.0  18432.0    0.3   16.5   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17406.6    0.3   15.8   0  30                  0.0      0.0    0.0    0.0   0   0
19.0  17424.1    0.3   15.9   0  29                  0.0      0.0    0.0    0.0   0   0
19.0  17408.1    0.3   16.0   0  29                  0.0      0.0    0.0    0.0   0   0
19.0  17393.0    0.3   16.5   0  31                  0.0      0.0    0.0    0.8   0   0
21.0  18448.4    0.3   14.9   0  31                  0.0      0.0    0.0    0.0   0   0
17.0  17391.7    0.3   17.3   0  29                  0.0      0.0    0.0    0.0   0   0
20.0  18432.2    0.3   15.5   0  31                  0.0      0.0    0.0    0.0   0   0
17.0  17407.9    0.3   18.2   0  31                 16.0  14519.9    0.3   19.3   0  28
20.0  18432.1    0.3   15.8   0  32                 20.0  18448.0    0.3   16.4   0  32
17.0  17407.9    0.3   17.6   0  30                 17.0  17392.1    0.3   17.7   0  30
20.0  18432.1    0.3   15.9   0  31                 20.0  18432.0    0.3   15.8   0  31
19.0  17422.2    0.3   16.7   0  31                 18.0  18432.3    0.3   17.5   0  32
19.0  18801.9    0.3   16.0   0  30                 24.0  18446.2    0.4   15.5   0  32
19.0  17302.6    0.3   17.4   0  33                 20.0  17393.2    0.3   16.4   0  32
18.0  18152.2    0.3   16.8   0  30                 20.0  18432.2    0.3   16.6   0  33
19.0  17408.5    0.3   15.2   0  28                 19.0  17407.8    0.3   16.9   0  32
18.0  18431.8    0.3   18.1   0  33                 19.0  18432.0    0.3   16.7   0  32
19.0  17409.0    0.3   16.2   0  31                 19.0  17424.2    0.3   16.0   0  29
20.0  18448.2    0.3   16.7   0  32                 18.0  18416.1    0.3   16.8   0  30
18.0  18415.4    0.3   17.7   0  32                 19.0  17407.8    0.3   15.8   0  30
20.0  18432.4    0.3   17.2   0  34                 18.0  18432.2    0.3   17.0   0  31
18.0  18432.3    0.3   17.5   0  31                 36.0  34815.5    0.7   20.7   0  53
25.0  17519.6    0.4   15.3   0  34                 75.0  70651.4    1.7   22.5   0  99
21.0  18318.5    0.3   15.6   0  33                 72.0  69635.0    1.7   23.4   0  99
18.0  18390.2    0.3   17.8   0  32                 73.0  73282.1    1.7   22.8   0  99
20.0  18473.6    0.3   15.0   0  31                 73.0  73146.4    1.7   23.0   0  99
18.0  17409.6    0.3   17.3   0  31                 75.0  74037.4    1.7   22.4   0  98
20.0  18446.8    0.3   15.9   0  31                 73.0  70344.9    1.7   23.3   0  99
17.0  17392.2    0.3   17.5   0  30                 76.0  73729.0    1.7   22.2   0 100
20.0  18432.1    0.3   16.2   0  32                 79.0  71684.4    1.8   22.2   0  99
17.0  17408.0    0.3   17.0   0  29                 20.0  17223.5    0.4   18.7   0  22
42.0  38918.2    0.9   21.1   0  60                  0.0      0.0    0.0    0.0   0   0
74.0  71670.7    1.7   22.6   0  99                  0.0      0.0    0.0    0.0   0   0
71.0  68608.2    1.7   23.5   0  99                  0.0      0.0    0.0    0.9   0   0
72.0  71679.6    1.6   22.9   0  99                 12.0  10423.5    0.2   18.3   0  19
72.0  72704.6    1.6   22.9   0  99                 28.0  26626.4    0.5   17.7   0  48
72.0  70970.1    1.7   23.1   0  98                 30.0  28672.7    0.5   16.7   0  49
72.0  69317.5    1.7   23.2   0  99                 31.0  29695.3    0.5   16.2   0  49
75.0  72697.6    1.7   22.2   0  99                 31.0  29697.0    0.6   17.9   0  54
77.0  69636.2    1.7   21.9   0  98                  4.0   3912.1    0.1   12.5   0   5
92.0  65180.0    1.7   18.9   0  97                  0.0      0.0    0.0    0.0   0   0
79.0  71668.9    1.7   21.3   0 100                  0.0      0.0    0.0    0.0   0   0
75.0  70665.6    1.7   22.2   0  98                  0.0      0.0    0.0    0.0   0   0
76.0  68603.8    1.7   22.2   0  99                  0.0      0.0    0.0    0.0   0   0
68.0  64513.8    1.5   21.7   0  90                  0.0      0.0    0.0    0.0   0   0
32.0  26704.8    0.5   16.1   0  47                  0.0      0.0    0.0    0.0   0   0
25.0  25519.2    0.4   17.2   0  43                  0.0      0.0    0.0    0.0   0   0
28.0  26625.4    0.4   15.6   0  44                  0.0      0.0    0.0    0.0   0   0
29.0  25847.4    0.5   16.7   0  47                  0.0      0.0    0.0    2.5   0   1
27.0  27399.2    0.5   18.1   0  49                  0.0      0.0    0.0    0.0   0   0
33.0  29714.6    0.5   15.6   0  50                  0.0      0.0    0.0    0.0   0   0
30.0  28653.4    0.5   17.0   0  50                  0.0      0.0    0.0    0.0   0   0
41.0  27236.3    0.6   15.3   0  54                 33.0  30912.6    0.6   17.5   0  54
30.0  28655.4    0.5   16.3   0  49                 31.0  29693.5    0.5   16.5   0  51
31.8  30524.1    0.5   16.0   0  50                 28.0  28672.0    0.5   17.9   0  50
30.2  29646.9    0.5   16.6   0  51                 34.0  30736.7    0.5   15.5   0  51
32.0  28863.9    0.5   16.2   0  51                 31.0  29680.0    0.5   17.2   0  53
33.0  30751.8    0.5   16.1   0  53                 31.0  29698.3    0.7   21.7   0  65
32.0  30720.6    0.5   16.4   0  52                 33.0  31743.2    0.5   16.3   0  54
31.0  29696.1    0.5   16.9   0  52                 35.0  31760.8    0.5   15.6   0  52
33.0  30720.0    0.5   16.5   0  54                 32.0  30704.0    0.5   16.7   0  53
31.0  29711.8    0.5   16.5   0  50                 34.0  32767.7    0.5   16.0   0  54
31.0  29680.1    0.5   16.7   0  52                 33.0  32767.4    0.6   17.1   0  56
29.0  28669.5    0.5   17.2   0  50                 35.0  31760.4    0.6   15.7   0  55
31.0  29696.8    0.5   16.7   0  51                 34.0  32752.3    0.6   16.4   0  56
29.0  27646.8    0.5   17.0   0  49                 35.0  33792.1    0.6   16.8   0  58
31.0  29696.2    0.5   15.9   0  49                 35.0  33790.9    0.6   16.3   0  56
31.0  29698.4    0.5   16.6   0  51                 34.0  32766.1    0.6   16.5   0  55
31.0  29696.4    0.5   16.1   0  50                 38.0  34834.6    0.6   16.4   0  61
34.0  30726.6    0.6   16.2   0  53                 34.0  33772.9    0.6   17.1   0  58
31.0  29688.8    0.5   16.7   0  51                 35.0  34817.1    0.6   16.3   0  57
33.0  31743.7    0.5   15.9   0  52                 34.0  33793.1    0.6   16.8   0  57
31.0  30488.4    0.5   17.2   0  53                 32.0  32766.5    0.6   17.5   0  56
33.0  31125.0    0.5   15.9   0  51                 33.0  32767.9    0.6   16.9   0  56
32.0  30544.6    0.5   16.9   0  53                 12.0  11072.9    0.2   16.2   0  19
33.0  31745.3    0.5   16.2   0  53                  0.0      0.0    0.0    0.0   0   0
35.0  32769.2    0.6   16.7   0  58                  0.0      0.0    0.0    0.0   0   0
32.0  30720.3    0.6   18.2   0  56                  0.0      0.0    0.0    0.0   0   0
34.0  32767.9    0.5   16.0   0  54                  0.0      0.0    0.0    0.0   0   0
35.0  33791.8    0.6   16.6   0  58                  0.0      0.0    0.0    0.0   0   0
34.0  32768.4    0.6   16.5   0  56                  0.0      0.0    0.0    0.0   0   0
36.0  32783.5    0.6   16.0   0  56                  0.0      0.0    0.0    0.0   0   0
36.0  34800.4    0.6   16.7   0  60                  0.0      0.0    0.0    0.0   0   0
36.0  34815.9    0.6   16.8   0  59                  0.0      0.0    0.0    0.9   0   0
35.0  34303.7    0.6   16.8   0  59                  0.0      0.0    0.0    0.0   0   0
34.0  34045.3    0.6   16.4   0  57                  0.0      0.0    0.0    0.0   0   0
32.0  31999.7    0.5   16.8   0  54                 35.0  31930.0    0.6   17.0   0  55
33.0  32768.6    0.5   16.7   0  55                 36.0  33791.9    0.6   16.1   0  57
40.0  27732.0    0.7   16.5   0  58                 36.0  33792.0    0.6   15.5   0  55
31.0  30718.9    0.5   17.3   0  54                 35.0  32768.3    0.6   16.8   0  56
32.0  31745.4    0.5   16.6   0  53                 36.0  33788.2    0.6   16.6   0  59
34.0  33535.5    0.6   16.7   0  57                 35.0  32766.5    0.6   16.7   0  58
32.0  32000.8    0.5   17.1   0  55                 39.0  33876.9    0.6   15.1   0  57
32.0  31740.0    0.6   18.0   0  57                 34.0  32703.7    0.6   16.7   0  56
35.0  32769.7    0.5   15.6   0  55                 34.0  33776.6    0.5   16.1   0  55
35.0  32758.9    0.6   16.4   0  57                 31.0  31744.8    0.5   17.6   0  54
35.0  31834.6    0.6   17.0   0  56                 33.0  33787.5    0.5   16.7   0  55
35.0  32687.0    0.6   16.4   0  56                 38.0  33792.0    0.6   15.7   0  59
34.0  33793.3    0.6   16.6   0  56                 32.0  31747.3    0.5   16.8   0  54
35.0  32767.5    0.6   16.7   0  58                 33.0  32767.5    0.6   16.9   0  56
38.0  32848.5    0.6   16.1   0  57                 50.0  49145.2    1.0   20.6   0  73
37.0  34735.8    0.6   15.9   0  59                 76.0  73757.4    1.7   22.4   0  99
36.0  33792.3    0.6   16.0   0  57                 74.0  73704.4    1.7   22.5   0  99
36.0  33788.9    0.6   15.8   0  56                 
35.0  32770.7    0.6   17.0   0  56 
35.0  32768.1    0.6   16.9   0  59 
36.0  33792.2    0.6   16.7   0  59 
39.0  33871.9    0.6   15.8   0  58 
35.0  33728.3    0.6   16.1   0  56 
34.0  33775.4    0.6   16.6   0  56 
32.0  32767.9    0.5   17.1   0  55 
33.0  33792.2    0.6   17.4   0  57 
38.0  33791.9    0.6   15.4   0  58 
33.0  32768.1    0.6   16.7   0  55 
32.9  32707.8    0.6   16.8   0  55 
53.1  52318.6    1.1   20.9   0  77 
74.0  71704.1    1.7   22.9   0 100 
74.0  73703.6    1.7   22.5   0 100 

Low Density FOV (up)

Skinny Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :

real    0m2.488s                                    real    0m1.935s
user    0m0.019s                                    user    0m0.019s
sys     0m0.015s                                    sys     0m0.015s

 r/s     kr/s   actv  svc_t  %w  %b                 r/s  kr/s   actv  svc_t  %w  %b
32.9  10280.7    0.5   14.6   0  35                 0.0   0.0    0.0    0.0   0   0
24.0   5545.9    0.3   11.5   0  17

Fat Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :

real   0m10.513s                                    real    0m7.895s
user    0m0.020s                                    user    0m0.019s
sys     0m0.014s                                    sys     0m0.015s

 r/s     kr/s   actv  svc_t  %w  %b                 r/s    kr/s   actv  svc_t  %w  %b
62.3  48447.8    1.2   18.5   0  74                 0.0     0.0    0.0    0.0   0   0
41.1  25909.5    0.6   15.8   0  54                 0.0     0.0    0.0    0.0   0   0
36.0  22879.5    0.6   15.8   0  48                 0.0     0.0    0.0    0.0   0   0
48.0  43969.7    0.9   18.4   0  66                 0.0     0.0    0.0    0.0   0   0
39.0  32041.0    0.7   19.1   0  51                 0.0     0.0    0.0    0.0   0   0
28.0  16497.9    0.4   14.7   0  33                 0.0     0.0    0.4   19.2   0   3
24.0  15210.2    0.4   15.5   0  30                 0.0     0.0    0.0    0.9   0   0
31.0  29685.6    0.7   21.1   0  48 
56.0  34247.2    0.9   16.4   0  64 
38.0  26476.2    0.6   15.7   0  50

Average Density FOV (up)

Skinny Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :
 
real    0m8.013s                                    real    0m7.005s
user    0m0.019s                                    user    0m0.020s
sys     0m0.014s                                    sys     0m0.014s

 r/s     kr/s   actv  svc_t  %w  %b                  r/s    kr/s   actv  svc_t  %w  %b
98.1  11373.4    1.8   18.1   0  41                  0.0     0.0    0.0    0.0   0   0
21.0   9341.0    0.3   15.7   0  26                  0.0     0.0    0.0    0.0   0   0
26.0  13972.4    0.4   14.5   0  28                  0.0     0.0    0.0    0.0   0   0
19.0   5283.1    0.2   11.6   0  16                  0.0     0.0    0.0    0.0   0   0
 7.0   4050.6    0.1    9.9   0   7                  0.0     0.0    0.0    0.0   0   0
40.0  18068.4    0.6   14.9   0  41                  0.0     0.0    0.0    0.0   0   0
19.0   9162.1    0.3   14.1   0  20                  
19.0   9604.0    0.3   16.0   0  23

Fat Tables

Run 1                                               Run 2 
                                                    (OS has the opportunity to
                                                     cache from run 1)

Time elapsed :                                      Time elapsed :

real   0m42.883s                                    real   0m35.005s
user    0m0.019s                                    user    0m0.019s
sys     0m0.014s                                    sys     0m0.016s

  r/s     kr/s   actv  svc_t  %w  %b                r/s    kr/s   actv  svc_t  %w  %b
 59.3  46334.4    1.1   18.4   0  74                0.0     0.0    0.0    0.0   0   0
 35.0  34819.2    0.6   16.8   0  59                0.0     0.0    0.0    0.0   0   0
 35.0  34805.3    0.6   16.6   0  58                0.0     0.0    0.0    0.0   0   0
 34.0  34827.2    0.6   17.3   0  59                0.0     0.0    0.0    0.0   0   0
 43.0  30154.5    0.7   16.2   0  60                0.0     0.0    0.0    0.0   0   0
 37.0  34813.6    0.6   16.9   0  61                0.0     0.0    0.0    0.0   0   0
 36.0  35840.4    0.6   16.7   0  60                0.0     0.0    0.0    0.0   0   0
 36.0  36863.6    0.6   17.0   0  61                0.0     0.0    0.1    8.8   0   2
 43.0  30754.2    0.7   15.2   0  59                0.0     0.0    0.0    0.0   0   0
 37.0  36608.5    0.6   16.9   0  62                0.0     0.0    0.0    0.0   0   0
 73.0  63266.4    1.6   21.3   0  92                0.0     0.0    0.0    0.0   0   0
 72.0  64590.5    1.7   23.3   0  98                0.0     0.0    0.0    0.0   0   0
 28.0  28671.7    0.6   20.4   0  44                0.0     0.0    0.0    0.8   0   0
 18.0  18432.7    0.3   18.4   0  33                0.0     0.0    0.0    0.0   0   0
 18.0  18432.4    0.3   17.7   0  32                0.0     0.0    0.0    0.0   0   0
 19.0  18431.9    0.3   16.1   0  31                0.0     0.0    0.0    0.0   0   0
 21.0  19456.2    0.3   15.1   0  31                0.0     0.0    0.0    0.0   0   0
 18.0  18431.9    0.3   17.0   0  31                0.0     0.0    0.0    0.0   0   0
 21.0  16026.3    0.4   17.2   0  33                0.0     0.0    0.0    0.0   0   0
 18.0  18431.7    0.3   17.6   0  32                0.0     0.0    0.0    0.0   0   0
 20.0  19446.3    0.3   15.5   0  31                0.0     0.0    0.0    0.0   0   0
 19.0  18440.1    0.3   15.9   0  30                0.0     0.0    0.0    0.0   0   0
 18.0  18432.9    0.3   17.1   0  31                0.0     0.0    0.2   12.3   0   3
 19.0  18430.7    0.3   16.4   0  30                0.0     0.0    0.0    0.0   0   0
 18.0  18433.3    0.3   17.0   0  31                0.0     0.0    0.0    0.0   0   0
 17.0  16640.4    0.3   16.4   0  28                0.0     0.0    0.0    0.0   0   0
 23.0  17522.2    0.4   16.8   0  35                0.0     0.0    0.0    0.0   0   0
 19.0  18432.0    0.3   16.0   0  30                0.0     0.0    0.0    0.0   0   0
 21.0  20743.0    0.4   18.0   0  36                0.0     0.0    0.0    0.0   0   0
 70.0  60384.8    1.6   22.4   0  92                0.0     0.0    0.0    0.0   0   0
109.0  62506.6    5.7   52.1   0 100                0.0     0.0    0.0    0.0   0   0
150.0  65935.6    5.0   33.1   0 100                0.0     0.0    0.0    0.0   0   0
 56.0  53829.6    1.1   20.3   0  77                0.0     0.0    0.0    0.0   0   0
 76.0  25459.4    4.0   52.4   0  64                0.0     0.0    0.0    0.0   0   0
 31.0  31744.9    0.5   17.7   0  54                
 33.0  30717.8    0.5   16.3   0  53 
 58.0  29808.8    0.8   13.6   0  53 
 61.0  29525.7    2.1   34.2   0  56 
 37.0  34874.6    0.6   16.3   0  59 
103.0  28649.8    4.1   39.9   0  67 
 32.0  30928.8    0.6   17.3   0  55 
 74.0  34784.5    2.4   32.5   0  71