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.