It’s very slow at writing over NFS. I wrote a simple python script writing 1000 entries, committing after each one, in WAL mode. In Fedora 22 VMs, NFS4.2 default settings, no security, SSD on host machine.
- local speed = 2 seconds
- NFS to another VM = 31 seconds
- NFS via localhost = 17 seconds
I tried the same test on a different system with spinning drives, it took 1 minute 43 seconds. The resulting file is 12kb (all inserts, no deletes or updates). It’s sync writes that are slow.
