Re: 7.4b1 vs 7.3.4 performance

On Thu, 21 Aug 2003 12:55:35 +0530
Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:

> On Wednesday 20 August 2003 22:43, rovero wrote:
> > expect wrote:
> > > Where does pgbench come from?
> >
> > pgbench is one of the modules in the postgresql
> > contrib directory. After building postgresql,
> > cd to contrib/pgbench, gmake, su to root,
> > gmake install.
> >
> > > What were the config settings?
> >
> > Both 7.3.4 and 7.4 had:
> >
> > 3072 buffers
> > 4096K sort memory
> > 16384K vacuum memory
>
> Since you weren't running any huge sorts thr. pgbench and vacuum, canyou drop
> last two to half of these and check?

Just trying to learn a little more about pg perf. behavior....
Are you suggesting that with less memory to "manage" that pg
will run more efficiently?

>
> > fsync false
> > 16 WAL buffers
> > statistics on
>
> I would put more WAL buffers. 32-64 maybe..

It would be interesting to see 10 or 20 plateaus for that number or
at least up to the point of diminishing returns for the load that's applied.
Or maybe it wouldn't? Maybe it scales.

>
> Shridhar
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>