> I just made another test with a second Gentoo machine: > > Pentium 4 3.0Ghz Prescott > GCC 4.1.1 > Glibc 2.4 > PostgreSQL 8.1.5 > Kernel 2.6.17 > > Same postgresql.conf as yesterday's. > > First test > ========== > GLIBC: -O2 -march=i686 > PostgreSQL: -O2 -march=i686 > Results: 974.638731 975.602142 975.882051 969.142503 992.914167 > 983.467131 983.231575 994.901330 970.375221 978.377467 > Average (error): 980 tps (13 tps)
Do you have any scripts for the above process you could share with the list? I have a few machines (a woodcrest and an older Xeon) that I could run this on... Thanks, Bucky ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
