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

Robert Ford schrieb am 02.03.2020 um 15:42:
> 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?

I think the major Linux file systems do still outperform NTFS.

But you might want to consider something else:

Most of the interesting extensions and tools only work on Linux - that includes administration tools like barman,
pg_backor repmgr. 

So preferring one over the other, is not only about performance, but might also be about administration.