alt Hacker NewsSo one trick you can do is make a ramfs/tmpfs and start Postgres on it.
You need a server with enough ram to fit it all.
But it kind of make the database fly.
Replies
lossolo • yesterday at 11:01 PM
Or you can also just place one or more tables on tmpfs, we are doing that in production.
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.