> Tom Lane wrote:
> >
> > > platform) i686-pc-linux-gnu, compiled by GCC
> egcs-2.91.60(turbolinux 4.2)
> > > min delay) 10msec according to your test program.
> > > -B) 64 (all other settings are default)
> >
> > Thanks. Could I trouble you to run it again with a larger -B, say
> > 1024 or 2048? What I've found is that at -B 64, the benchmark is
> > so constrained by limited buffer space that it doesn't reflect
> > performance at a more realistic production setting.
> >
>
> Hmm the result doesn't seem that obvious.
>
I tried with -B 1024 10 times for commit_delay=0 and 1 respectively.
The average result of 'pgbench -c 10 -t 100' is as follows.
[commit_delay=0]26.462817(including connections establishing)26.788047(excluding connections establishing)
[commit_delay=1]27.630405(including connections establishing)28.042666(excluding connections establishing)
Hiroshi Inoue