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

From: Roberto Della Pasqua <roberto(dot)dellapasqua(at)live(dot)com>
To: Robert Ford <robfordww(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: R: Postgresql 12.x on Windows (vs Linux)
Date: 2020-03-02 15:01:34
Message-ID: AM0PR0502MB3650836EF6002C25848BF09B99E70@AM0PR0502MB3650.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well,

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

best regards
RF

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2020-03-02 15:06:23 Re: Postgresql 12.x on Windows (vs Linux)
Previous Message Thomas Kellerer 2020-03-02 14:57:54 Re: Postgresql 12.x on Windows (vs Linux)