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_back or repmgr. So preferring one over the other, is not only about performance, but might also be about administration.
