Re: 7.4b1 vs 7.3.4 performance

On Wed, 20 Aug 2003 13:13:38 -0400
rovero <rovero@sonalysts.com> 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.

Thank you.

>
> > What were the config settings?
>
> Both 7.3.4 and 7.4 had:
>
> 3072 buffers
> 4096K sort memory
> 16384K vacuum memory
> fsync false
> 16 WAL buffers
> statistics on


I don't know a lot about TPC but I understand it's meant to mimic
multiple teller xactions and that's what you did.  This is not a
request mind you but it would be interesting to see how changing
those configs would alter the performance behavior.