| 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% | |||