Hi,
While we are at async i/o. I think direct i/o and concurrent i/o also deserve a look at. The archives suggest that Bruce had some misgivings about dio because of no kernel caching, but almost all databases seem to (carefully) use dio (Solaris, Linux, ?) and cio (AIX) extensively nowadays.
Zeugswetter Andreas ADI SD wrote:
POSIX_FADV_WILLNEED definitely sounds very interesting, but:
I think this interface was intended to hint larger areas (megabytes).
But the wishful thinking was not to hint seq scans, but to advise
single 8k pages.
Surely POSIX_FADV_SEQUENTIAL is the one
On Tue, Oct 24, 2006 at 12:53:23PM -0700, Ron Mayer wrote:
Anyway, for those who want to see what they do in Linux,
http://www.gelato.unsw.edu.au/lxr/source/mm/fadvise.c
Pretty scary that Bruce said it could make older linuxes
dump core - there isn't a lot of code there.
The bug was