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

Your comment assumes that OP does not have have a site license, and does have Linux expertise.  Neither assumption is always valid.

(And, of course, the Windows server might already exist.)

But why even bother paying for MS licenses? Postgres runs like a train
on Linux. Save your money.

Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420

On 02/03/2020 15:01, Roberto Della Pasqua wrote:

Well,

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?

best regards

RF

Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/



Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.