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
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?