Advertising

I was curious to see how postgres would perform with wal on a tmpfs vs
disk here are some numbers I got from pgbench. Let me know if I did
something stupid, this is the first time I've used pgbench. The wal on tmpfs
method is not significantly faster.

tmpfs uses virtual memory, so it is likely hitting the disk. I would try
and repeat your cases with ramfs, which uses real memory. Testing shows
that just putting pg_xlog on ramfs yields a 30% boost in performance over
disk with a stock configuration. So there is room for improvement, I am
sure.