Hi Robert
I've used Postgresql on windows for years. Yes there are performance differences between windows and linux and the gap has gotten bigger with JIT
Common performance hits
Shared Buffers
JIT not supported
Windows can be aggressive flushing its disk cache,
Running Postgresql using HyperV had big performance hit in my setup it was 30% hit between the VM vs the Hosted OS.
Switch to Linux to get JIT and saw significant improvement on specific queries, for general use it was marginal improvement once the hardware difference was factored out
On Mon, Mar 2, 2020 at 9:42 AM Robert Ford <robfordww@xxxxxxxxx> wrote:
I am aware that this might be a broad question, but I am not expecting very specific answers either:When it come to running a modern PostgreSQL server, which serves say 1 TB of data, are there substantial differences in performance between Windows Server 2019 and Linux today? I know there are some issues with shared_buffers and windows, but does it manifest in real performance issues?I have searched the web for this question, but is surprised to find very few concrete benchmarks on this. Anyone with real world experience on this topic?best regardsRF
