Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > John Hansen wrote: > >> On another note, how do you know for sure, that your drive does not lie > >> about fsync? > > > I just tried and got 115tps with fsync off vs 100 with fsync on, so > > fsync is certainly doing something. > > [ raised eyebrow... ] Something is wrong with that. I'd expect a > *much* higher difference. It's difficult to credit a tps rate higher > than your disk's RPM rating with fsync on, but most modern CPUs can do > a lot better than that with fsync off. If you have a 7200 RPM drive > then I'd believe the 100 figure, but not the other ...
I think it is a 10k RPM drive, Seagate Cheteetah ST336607LW. -- 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
