Using current CVS (yesterday) I've rerun the benchmarks to see the effects of various NAMEDATALEN settings.
3 times per setting. First time is pgbench inserts (-s 5) Second time is pgbench run (-t 3000 -s 5) Third time is the postmaster during both of the above. I'll run it again tonight on a computer with faster disk I/O to see if that helps descrease the sys times. ----- NAMEDATALEN: 32 89.34 real 1.85 user 0.13 sys 146.87 real 1.51 user 3.91 sys 246.63 real 66.11 user 19.21 sys NAMEDATALEN: 64 93.10 real 1.82 user 0.16 sys 147.30 real 1.45 user 3.90 sys 249.28 real 66.01 user 18.82 sys NAMEDATALEN: 128 99.13 real 1.80 user 0.51 sys 169.47 real 1.87 user 4.54 sys 279.16 real 67.93 user 29.72 sys NAMEDATALEN: 256 106.60 real 1.81 user 0.43 sys 166.61 real 1.69 user 4.25 sys 283.76 real 66.88 user 26.59 sys
NAMEDATALEN: 32 89.34 real 1.85 user 0.13 sys 146.87 real 1.51 user 3.91 sys 246.63 real 66.11 user 19.21 sys NAMEDATALEN: 64 93.10 real 1.82 user 0.16 sys 147.30 real 1.45 user 3.90 sys 249.28 real 66.01 user 18.82 sys NAMEDATALEN: 128 99.13 real 1.80 user 0.51 sys 169.47 real 1.87 user 4.54 sys 279.16 real 67.93 user 29.72 sys NAMEDATALEN: 256 106.60 real 1.81 user 0.43 sys 166.61 real 1.69 user 4.25 sys 283.76 real 66.88 user 26.59 sys NAMEDATALEN: 512 88.13 real 1.83 user 0.22 sys 160.77 real 1.64 user 4.48 sys 259.56 real 67.54 user 21.89 sys
#!/bin/sh PGSRC=/home/rbt/postgresql/pgsqlnamedatalen PGBASEPORT=6400 PGBASEBIN=/home/rbt/postgresql/dbname LOG=/home/rbt/bench_namedatalen.log for newDATALEN in 32 64 128 256 512 ; do PGBIN=${PGBASEBIN}_${newDATALEN} PGPORT=`echo "${PGBASEPORT}+${newDATALEN}" | bc` sed -E 's/NAMEDATALEN\s[0-9]+/NAMEDATALEN ${newDATALEN}/g' ${PGSRC}/src/include/postgres_ext.h > ${PGSRC}/src/include/postgres_ext.h.tmp mv ${PGSRC}/src/include/postgres_ext.h.tmp ${PGSRC}/src/include/postgres_ext.h cd ${PGSRC} ./configure --prefix=${PGBIN} --with-pgport=${PGPORT} || (echo "UNABLE TO CONFIGURE"; exit) make clean make clean install cd ${PGSRC}/contrib/pgbench gmake install ${PGBIN}/bin/initdb -D ${PGBIN}/data || (echo "UNABLE TO INITIALIZE"; exit 1) time -a -o ${LOG} ${PGBIN}/bin/postmaster -D ${PGBIN}/data -F & sleep 5 echo "NAMEDATALEN: ${newDATALEN}" >> ${LOG} echo >> ${LOG} time -a -o ${LOG} ${PGBIN}/bin/pgbench -i -s 5 -d template1 -p ${PGPORT} time -a -o ${LOG} ${PGBIN}/bin/pgbench -t 3000 -s 5 -d template1 -p ${PGPORT} echo >> ${LOG} ${PGBIN}/bin/pg_ctl -D ${PGBIN}/data stop echo >> ${LOG} echo >> ${LOG} rm -rf ${PGBIN} done
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly