> > > I ran some tests last week and can report results similar on Tom's test:
> > >
> > > pgbench -i -s 10 bench
> > > pgbench -c 10 -t 10000 bench
> > >
don't you have to specify the scaling factor for the benchmark as well?
as in pgbench -c 10 -t 10000 -s 10 bench ?
> I just tried and got 115tps with fsync off vs 100 with fsync on, so
> fsync is certainly doing something.
well, I usually get results that differ by that much from run to run.
Probably you ran in to more checkpoints on the second test.
Also, did you reinitialize the bench database with pgbench -i ?
... John