on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware.
Da: Robert Ford <robfordww@gmail.com> Inviato: lunedì 2 marzo 2020 15:42 A: pgsql-general@lists.postgresql.org Oggetto: Postgresql 12.x on Windows (vs Linux)
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?