On 2/12/07,
Gene <
genekhart@gmail.com> wrote:
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.
