Or you can also just place one or more tables on tmpfs, we are doing that in production.