upvote
You can certainly do that, but it'll perform much worse than properly tuning your Postgresql to take advantage of requiring no durability and having lots of RAM. Source: I do this kind of thing for a living.
reply
Or you can also just place one or more tables on tmpfs, we are doing that in production.
reply