3 ms·
So 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.
by 3dedb728-3f77 2mo ago
So 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.
- lossolo 2mo agoOr you can also just place one or more tables on tmpfs, we are doing that in production.
- shdnx 2mo agoYou 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.