Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> I changed pgbench so that different connection connects
> to the different database and got the following results.
Hmm, you mean you set up a separate test database for each pgbench
"client", but all under the same postmaster?
> The results of
> pgbench -c 10 -t 100
> [CommitDelay=0]
> 1st)tps = 18.484611(including connections establishing)
> tps = 19.827988(excluding connections establishing)
> 2nd)tps = 18.754826(including connections establishing)
> tps = 19.352268(excluditp connections establishing)
> 3rd)tps = 18.771225(including connections establishing)
> tps = 19.261843(excluding connections establishing)
> [CommitDelay=1]
> 1st)tps = 20.317649(including connections establishing)
> tps = 20.975151(excluding connections establishing)
> 2nd)tps = 24.208025(including connections establishing)
> tps = 24.663665(excluding connections establishing)
> 3rd)tps = 25.821156(including connections establishing)
> tps = 26.842741(excluding connections establishing)
What platform is this on --- in particular, how long a delay
is CommitDelay=1 in reality? What -B did you use?
regards, tom lane