Gavin Sherry <[EMAIL PROTECTED]> writes: > A filesystem could, in theory, help us by providing an API which allows us > to tell the file system either: the way we'd like it to read ahead, the > fact that we don't want it to read ahead or the way we'd like it to cache > (or not cache) data. The thing is, most OSes provide interfaces to do this > already and we make only little use of them (I'm think of > madv_sequential(), madv_random(), POSIX fadvise(), the various flags to > open() which AIX, HPUX, Solaris provide).
Yeah ... the main reason we've not spent too much time on that sort of stuff is that *it's not portable*. And with all due respect to Hans, special tweaks for one filesystem are even less interesting than special tweaks for one OS. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq