On Thu, 25 Apr 2002, Bruce Momjian wrote: > Also keep in mind most disks have 512 byte blocks, so even if the file > system is 8k, the disk block sizes are different. A given 8k or 1k file > system block may not even be all in the same cylinder.
Right. Though much of the time they will be in the same cylinder, sometimes they will be in adjacent cylinders if the drive manufacturer has made cylinder sizes that are not multiples of 8K. I don't think this is terribly frequent, but there's no way to substantiate that assumption without knowing the real geometries of the drive, which generally are not given out. (What is reported to the OS has not been the real geometry for years now, because drive manufacturers long ago started putting more blocks on the outer cylinders than the inner ones.) However, even that they will be in adjacent cylinders doesn't always hold: depending on how the disk subsystems are partitioned, you might be crossing a boundary where two partitions are joined together, necessitating a seek. But this case would be quite rare. You can always find conditions, in modern drive subsystems, where the "read close together" idea doesn't hold, but in the vast, vast majority of circumstances it does. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html