Postgres Numbers (5/15/1994) (2000 buffers) (loading time: polygon: 1007.1 points: 100.0 islands: 162.1 rasters: 708.8 index + vacuum: 10953.1)* * These load numbers are affected by a compilation, and should not represent postgres true performance. See next batch of numbers for real load time of postgres. run1 run2 run3 run4 run5 Q1 Q2 13.6 16.1 15.8 14.4 Q3 7.0 9.7 9.1 8.7 Q4 1.6 1.3 1.3 1.4 Q5 1.3 2.0 1.2 1.4 Q6 110.0 109.9 113.4 113.2 Q7 59.8 61.3 59.7 60.8 Q8 177.0 188.1 180.6 194.5 Q9 5.0 5.1 6.5 5.9 Q10 302.6 306.0 311.1 297.1 Postgres Numbers (5/16/1994) (2000 buffers) (loading time: polygon: 1009.1 points: 55.9 islands: 92.8 rasters: 549.3 index + vacuum: 9460.5) run1 run2 run3 run4 run5 Q1 Q2 13.2 16.9 17.0 15.1 14.0 Q3 8.5 8.7 9.0 8.2 8.7 Q4 0.8 1.3 1.4 1.4 1.7 Q5 1.0 1.1 1.1 1.3 1.3 Q6 116.6 113.4 115.6 120.3 116.7 Q7 75.0 61.0 63.0 60.9 60.5 Q8 182.7 169.5 168.0 171.4 183.0 Q9 5.9 5.5 6.1 5.8 5.2 Q10 307.4 307.5 294.2 305.7 376.2 (64 buffers, run after the above queries) run1 run2 run3 run4 Q1 Q2 14.1 13.0 13.4 13.1 Q3 8.2 7.3 5.8 5.8 Q4 1.4 0.7 2.0 2.0 Q5 1.0 0.9 1.4 1.1 Q6 37.4 37.4 37.0 37.6 Q7 32.5 32.5 31.7 33.4 Q8 87.1 86.1 86.2 86.6 Q9 3.2 3.1 3.1 3.3 Q10 333.9 335.5 335.7 333.3 Postgres Numbers (6/02/1994) (64 buffers) (loading time: polygon: 1112.6 points: 86.3 islands: 197.0 rasters: 547.0 index + vacuum: 8622.4) (64 buffers, run after the above queries) run1 run2 run3 run4 run5 avg(3) best Q1 10565.3 Q2 12.9 13.4 14.2 13.7 13.6 13.5 12.9 Q3 4.6 5.2 5.8 5.6 5.6 5.4 4.6 Q4 1.3 1.3 1.4 1.3 1.4 1.3 1.3 Q5 0.8 1.0 0.9 0.9 1.0 0.9 0.8 Q6 39.2 39.1 39.5 38.8 38.7 39.0 38.8 Q7 33.3 31.1 31.7 31.7 32.1 31.8 31.1 Q8 85.7 86.3 86.9 87.1 86.8 86.6 85.7 Q9 2.7 2.9 3.1 3.0 3.1 3.0 2.7 Q10 339.4 341.6 331.2 334.6 329.0 335.0 329.0 (128 buffers, run after the above queries) run1 run2 run3 run4 run5 avg(3) best Q1 10565.3 Q2 14.9 13.2 12.9 13.5 14.9 13.8 12.9 Q3 5.7 6.6 5.9 6.6 6.7 6.3 5.7 Q4 1.4 1.3 1.4 0.8 1.5 1.3 0.8 Q5 1.3 0.9 1.2 1.0 1.2 1.1 0.9 Q6 38.2 38.4 37.8 37.5 38.0 38.0 37.5 Q7 31.8 33.2 32.5 34.6 33.2 32.9 31.8 Q8 87.5 87.7 86.5 86.5 88.8 87.2 86.5 Q9 3.1 3.1 3.2 3.3 3.4 3.2 3.1 Q10 345.6 340.9 339.5 339.4 338.4 339.9 338.4 Postgres Numbers (6/04/1994) ***Q8 is corrected with constant 25000 for makebox*** (64 buffers) (loading time: polygon: 1053.2 points: 89.0 islands: 189.0 rasters: 546.8 index + vacuum: 8687.0) run1 run2 run3 run4 run5 avg(3) best Q1 10565.0 Q2 13.1 13.4 13.2 14.8 13.6 13.4 13.1 Q3 4.4 4.8 5.7 5.8 6.0 5.4 4.4 Q4 1.2 1.2 1.3 1.3 1.4 1.3 1.2 Q5 0.8 0.8 1.0 0.9 0.9 0.9 0.8 Q6 36.1 37.2 36.1 35.8 35.2 36.0 35.2 Q7 31.3 31.0 29.4 30.0 30.6 30.5 29.4 Q8 61.9 60.7 63.0 62.1 62.6 62.2 60.7 Q9 2.7 2.6 2.9 2.9 2.8 2.8 2.6 Q10 333.1 329.7 325.5 326.4 322.1 327.2 322.1 (run after the above run) (64 buffers) run1 run2 run3 run4 run5 avg(3) best Q2 15.2 14.8 13.9 13.2 13.1 13.9 13.1 Q3 5.4 5.5 5.4 6.3 5.6 5.5 5.4 Q4 1.3 1.3 1.3 1.4 1.3 1.3 1.3 Q5 0.9 1.0 1.0 0.9 1.0 0.9 0.9 Q6 36.2 36.0 36.0 35.7 35.8 35.9 35.8 Q7 29.7 29.5 29.7 29.4 29.2 29.5 29.2 Q8 63.6 62.3 62.4 63.6 62.8 62.9 62.3 Q9 3.1 3.1 3.1 3.2 3.1 3.1 3.1 Q10 330.3 325.2 328.7 324.9 330.1 328.0 324.9 * retrieve (a = count { gpoints.oid })\g Query sent to backend is "retrieve (a = count { gpoints.oid })" --------------- | a | --------------- | 62556 | --------------- * retrieve (a = count { polygons.oid })\g Query sent to backend is "retrieve (a = count { polygons.oid })" --------------- | a | --------------- | 60650 | --------------- * retrieve (a = count {rasters.oid} )\g Query sent to backend is "retrieve (a = count {rasters.oid} )" --------------- | a | --------------- | 130 | --------------- * retrieve (a = count {islands.oid} )\g Query sent to backend is "retrieve (a = count {islands.oid} )" --------------- | a | --------------- | 21091 | --------------- Q5 1 Q6 701 Q7 1 Q8 2472 Q8 746 * with 25000 constant