2 ms·
No matter what, PostgreSQL can't (trivially) run in-memory only, and even Unix sockets has a performance cost compared to a library running in the same address
by mschuster91 3y ago
No matter what, PostgreSQL can't (trivially) run in-memory only, and even Unix sockets has a performance cost compared to a library running in the same address space.
- charcircuit 3y agoIt should be trivial to set it up on a ramdisk and I see some guides on doing so when I search for "postgres ramdisk"
- mschuster91 3y agoPHP SQLite in-memory effort is `$db = new PDO('sqlite::memory');`. With postgreSQL, you'll at least have to: 1. create the ramdisk 2. mount the ramdisk, configure systemd to automount it 3. modify the systemd unit file for psql to depend on the ramdisk 4. initialize all the psql data structures in the ramdisk mount folder