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

Not at all, we found that Linux "expertise" is 1/10 the cost of Windows
expertise. Time to plan for getting rid of the site license.

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

On 02/03/2020 15:32, Ron wrote:
> 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.)
>
> On 3/2/20 9:06 AM, Tim Clarke wrote:
>> 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(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
>>>
>> 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 toadmin(at)minerva(dot)info<mailto:admin(at)minerva(dot)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 Herehttps://www.manifest.co.uk/legal/ for further information.
>
> --
> Angular momentum makes the world go 'round.

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(at)minerva(dot)info<mailto:admin(at)minerva(dot)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.