> > I'm hoping someone can shed some light on these results. > > Not without a lot more detail on how you *got* the results. > What exactly did you do to force the various plan choices? > (I see some ridiculous choices of indexscans, for instance, > suggesting improper use of enable_seqscan in some cases.) > And what's the "cache rows" and "disk rows" stuff, and how do > you know that what you were measuring is actually what you > think it is? I have zero confidence in Windows-atop-ATA as a > platform for measuring disk-related behaviors, because I > don't think you can control or even know what caching is going on.
You can control the writeback-cache from Device Manager->(the disk)->Policies. And if that is turned off, fsync definitly should write through, just as on *nix. (write-cache is on by default, no surprise) AFAIK, you can't control what is cached for reading. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend