|
| 1 | +DBMS:PostgreSQL 6.2b10 |
| 2 | +OS:FreeBSD 2.1.5-RELEASE |
| 3 | +HardWare:i586/90, 24M RAM, IDE |
| 4 | +StartUp:postmaster -B 256 '-o -S 2048' -S |
| 5 | +Compiler:gcc 2.6.3 |
| 6 | +Compiled:-O, without CASSERT checking, with |
| 7 | +-DTBL_FREE_CMD_MEMORY (to free memory |
| 8 | +if BEGIN/END after each query execution) |
| 9 | + |
| 10 | +DB connection startup: 0.20 |
| 11 | +8192 INSERTs INTO SIMPLE (1 xact): 39.58 |
| 12 | +8192 INSERTs INTO SIMPLE (8192 xacts): 1190.98 |
| 13 | +Create INDEX on SIMPLE: 3.69 |
| 14 | +8192 INSERTs INTO SIMPLE with INDEX (1 xact): 46.65 |
| 15 | +8192 random INDEX scans on SIMPLE (1 xact): 65.49 |
| 16 | +ORDER BY SIMPLE: 2.27 |