On Wed, 20 Aug 2003 13:13:38 -0400
rovero <rovero(at)sonalysts(dot)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.