John Hansen wrote: > > 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 > > > > The tests were on a machine with a single SCSI drive that doesn't lie > > about fsync. I found 7.4.X got around 75tps while 8.0 got 100tps, very > > similar to the 65/107 numbers Tom had. > > You do realize, that pgbench result comparisons are about as useful as a > fork for eating soup?
> > On another note, how do you know for sure, that your drive does not lie > about fsync? > > Did you run the tests with fsync turned off vs fsync on? I just tried and got 115tps with fsync off vs 100 with fsync on, so fsync is certainly doing something. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html