3 ms·
Do you mean using postgres tablespaces backed by memory or do you mean using a FDW? If you do mean using a ramdisk tablespace, the postgres docs recommend not
by Cieplak 11y ago
Do you mean using postgres tablespaces backed by memory or do you mean using a FDW?
If you do mean using a ramdisk tablespace, the postgres docs recommend not doing that. However, if you really want to do that, make sure you attach xlog (the WAL table) to that ramdisk tablespace as well, otherwise every transaction will still hit the disk.
- hoodoof 11y agoPutting tables in RAM and setting the config as you suggest works just fine.
- anarazel 11y agoNot the poster upthread. But if you have enough memory (shared_buffers) and use unlogged tables, the effect is going to be that both reads and writes pretty much only hit memory, no disk. Without going through the trouble of moving tablespaces or anything.