This is pretty much how all DBMSs work right now. You have to tell it how much memory it can use for its internal buffer pool.