Database Architecture Blog
architecture-database.blogspot.com
architecture-database.blogspot.com
Just my 2¢
—signed, someone who went down that road a decade ago
Afaik it should be fully transparent; can you even reliably that it occurred?
I’m strictly asking, to be clear; I’m vaguely remembering an article about redis(?), describing db page-management as a poor design, as it ends up being unreliable to detect, and competes with the OS to neither’s benefit (though a similar argument is often made as to why you shouldn’t micro-optimize C — the compiler will win [except where it doesn’t])
you're absolutely right that you shouldn't have two page caches. but its entirely likely that the database has explicit lifetime and policy information that would make it a more effective cache owner. but sure, if you're just going to do a blind LRU, by all means leave it to the kernel.