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

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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