The size of postgresql database was ~74GB for every test combination. The bare metal server had 256GB RAM for every test combination. The only difference was the amount of RAM PostgreSQL could use - as specified in…
I think it's pretty fair to test each OS with its filesystem of choice. I'm aware that you can use ZFS on Linux, but I'm not (yet) brave enough to recommend ZFS+Linux. And yes there's btrfs but would you trust it with…
Before the benchmark I did some test with FreeBSD+ZFS with LZ4 on/off. The LZ4 CPU overhead was pretty negligible and performance was slightly better than without compression, due to lower IO usage. That's the reason…
There is a 30 min warmup period before the actual benchmark. It is shown in the benchmarking script.
Hello, OP here. I'm certain that you can fine tune every OS for specific use case. I may indeed do that in a future blogpost. The question is what to compare ? Should I compare Linux kernel versions, PostgreSQL…
The size of postgresql database was ~74GB for every test combination. The bare metal server had 256GB RAM for every test combination. The only difference was the amount of RAM PostgreSQL could use - as specified in…
I think it's pretty fair to test each OS with its filesystem of choice. I'm aware that you can use ZFS on Linux, but I'm not (yet) brave enough to recommend ZFS+Linux. And yes there's btrfs but would you trust it with…
Before the benchmark I did some test with FreeBSD+ZFS with LZ4 on/off. The LZ4 CPU overhead was pretty negligible and performance was slightly better than without compression, due to lower IO usage. That's the reason…
There is a 30 min warmup period before the actual benchmark. It is shown in the benchmarking script.
Hello, OP here. I'm certain that you can fine tune every OS for specific use case. I may indeed do that in a future blogpost. The question is what to compare ? Should I compare Linux kernel versions, PostgreSQL…