Page readahead

[penberg]

SQLite benefits from kernel readahead whereas we don't. Let's implement readahead in userspace.

[brayanjuls]

@penberg does implementing readahead in the userspace means storing more than one page in the buffer pool? Could you point me to any reference where I can read about it or code to try to understand how this should be implemented?

[arpit-saxena]

I'll take a shot at this. We have more context to do page lookup in userspace than the kernel does, so we ideally should be able to do better here.