[HACKERS] Re: [ADMIN] v7.1b4 bad performance

[Tatsuo Ishii]

lockhart> > ... See included png file.
lockhart> 
lockhart> What kind of machine was this run on?
lockhart> 
lockhart>                      - Thomas

Sorry to forget to mention about that.

SONY VAIO Z505CR/K (note PC)
Pentium III 750MHz/256MB memory/20GB IDE HDD
Linux (kernel 2.2.17)
configure --enable-multibyte=EUC_JP
postgresql.conf:
                fsync = on
                max_connections = 128
                shared_buffers = 1024
                silent_mode = on
                commit_delay = 0
postmaster opts for 7.0.3:
                -B 1024 -N 128 -S
pgbench settings:
                scaling factor = 1
                data excludes connetion establishing time
                number of total transactions are always 640
                           (see included scripts I ran for the testing)
------------------------------------------------------
#! /bin/sh
pgbench -i test
for i in 1 2 4 8 16 32 64 128
do
        t=`expr 640 / $i`
        pgbench -t $t -c $i test
        echo "===== sync ======"
        sync;sync;sync;sleep 10
        echo "===== sync done ======"
done
------------------------------------------------------
--
Tatsuo Ishii