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

Inoue, Hiroshi <inoue@tpf.co.jp>

From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Tom Lane <tgl@sss.pgh.pa.us>, "Schmidt, Peter" <peter.schmidt@prismedia.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-02-21T03:35:53Z
Lists: pgsql-hackers
I Inoue wrote:
> 
> 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.
> 
> First I got the following result.

Sorry I forgot to mention the -B setting of my previous
posting. All results are with -B 1024.

Regards,
Hiroshi Inoue