Today, if we want to make sure a specific database is more in-memory than others, we can built is as a 16K or 32K block size (while all others are the default 8K block size) and then assign an amount of "cache buffers" to 16K block DBs.
I would like to see for ANY database, the ability to have a separate "cache buffers" allocation. This will allow having better control on data that is more frequently used without the need to change the block size (which is sometimes not sutiable for the data structures on that DB)
Oct 25, 2023
Thank you for submitting the idea. The status has been changed to "Needs review".