|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. UNLOGGED tables |
|
|
Operating System: Suse-Linux 10.2 x86_64 |
|
|
|
|
|
|
2. 10GB shared buffers |
|
|
Hardware : 4 core (Intel(R) Xeon(R) CPU L5408 @
2.13GHz) |
|
|
|
|
|
3. Number of tuples - 2,000,000 |
|
RAM : 24GB |
|
|
|
|
|
|
|
|
|
4. Single connection |
|
|
|
|
|
|
|
|
|
|
|
|
5. All columns INT data type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL cols
has data |
|
Last
columns has NULLS |
|
|
64 cols |
300 cols |
800 cols |
|
800 cols
- 600 nulls |
800 cols - 300 nulls |
300 cols - 150 nulls |
300 cols - 250 nulls |
|
|
Execution time(ms) |
Execution
time(ms) |
Execution
time(ms) |
|
Execution
time(ms) |
space (pages) |
Execution
time(ms) |
space (pages) |
Execution
time(ms) |
space (pages) |
Execution
time(ms) |
space (pages) |
|
|
3780.463 |
12537.545 |
110927.318 |
|
9659.534 |
250000 |
70964.223 |
666667 |
7139.723 |
166667 |
3633.513 |
66667 |
|
|
3763.355 |
12395.152 |
117314.811 |
|
9660.523 |
250000 |
71137.35 |
666667 |
7181.817 |
166667 |
3690.42 |
66667 |
|
|
3861.599 |
12383.04 |
116850.063 |
|
9624.601 |
250000 |
71493.857 |
666667 |
7164.65 |
166667 |
3663.35 |
66667 |
|
|
3782.834 |
12384.603 |
114851.073 |
|
9708.767 |
250000 |
71358.109 |
666667 |
7027.79 |
166667 |
3680.935 |
66667 |
|
|
3784.745 |
12542.94 |
115328.117 |
|
9709.173 |
250000 |
71560.704 |
666667 |
7008.517 |
166667 |
3690.72 |
66667 |
|
|
3794.5992 |
12448.656 |
115054.2764 |
|
9672.5196 |
250000 |
71302.8486 |
666667 |
7104.499 |
166667 |
3671.788 |
66667 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3797.515 |
12243.555 |
114084.584 |
|
8728.914 |
222223 |
69659.69 |
666667 |
6942.56 |
166667 |
3388.882 |
58824 |
|
|
3783.741 |
12317.067 |
113870.478 |
|
8706.79 |
222223 |
69646.359 |
666667 |
6908.025 |
166667 |
3336.522 |
58824 |
|
|
3805.318 |
12232.241 |
112064.184 |
|
8589.396 |
222223 |
69853.287 |
666667 |
6841.875 |
166667 |
3359.254 |
58824 |
|
|
3770.726 |
12265.632 |
112872.178 |
|
8729.362 |
222223 |
69277.953 |
666667 |
6891.575 |
166667 |
3267.011 |
58824 |
|
|
3796.17 |
12303.039 |
114184.811 |
|
8685.041 |
222223 |
69728.952 |
666667 |
6914.374 |
166667 |
3325.61 |
58824 |
|
|
3790.694 |
12272.3068 |
113415.247 |
|
8687.9006 |
222223 |
69633.2482 |
666667 |
6899.682 |
166667 |
3335.456 |
58824 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.10% |
1.42% |
1.42% |
|
10.18% |
11.11% |
2.34% |
0.00% |
2.88% |
0.00% |
9.16% |
11.76% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|