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
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- Re: [ADMIN] v7.1b4 bad performance Bruce Momjian
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Tatsuo Ishii
- Re: [ADMIN] v7.1b4 bad performance Thomas Lockhart
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad perfor... Tatsuo Ishii
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance Hiroshi Inoue
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performanc... Hiroshi Inoue
- Re: [HACKERS] Re: [ADMIN] v7.1b4 bad perfor... Hiroshi Inoue
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- RE: [ADMIN] v7.1b4 bad performance The Hermit Hacker
- RE: [ADMIN] v7.1b4 bad performance Schmidt, Peter
- RE: [ADMIN] v7.1b4 bad performance Michael Ansley
- RE: [ADMIN] v7.1b4 bad performance Michael Ansley
- Re: [ADMIN] v7.1b4 bad performance Tom Lane
- Re: [ADMIN] v7.1b4 bad performance M Carling