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?
> fsync false
> 16 WAL buffers
> statistics on
I would put more WAL buffers. 32-64 maybe..
Shridhar