Re: Postgresql 12.x on Windows (vs Linux)

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,
https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/subsystem/cache-memory-management/

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(at)gmail(dot)com> 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 regards
> RF
>