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