Thanks for that - the tradeoff between performance and complexity in this case is clearer now. It's interesting how many different approaches there are when st

Thanks for that - the tradeoff between performance and complexity in this case is clearer now. It's interesting how many different approaches there are when stepping back and using some of the OS - for example where does MySQL/InnoDB fit in this? It seems they are intending you to use their buffer pool rather than the OS's disk cache (as they advise to make the buffer pool take large percentage of RAM), as opposed to Postgres where they recommend having shared_buffers as ~20% of RAM and leaving the rest for the OS to use. Is InnoDB doing something different here or is it just because they have a better cache implementation?