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

There's always a good time to re-examine that :D

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

On 02/03/2020 15:52, Ron wrote:
> LOL. Double LOL, even. We -- and a huge number of other
> organizations -- are completely wrapped in the Windows environment,
> from Outlook and Excel to SharePoint to the myriad of 3rd party
> programs that *only* work on Windows.
>
> On 3/2/20 9:37 AM, Tim Clarke wrote:
>> 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 ittoadmin(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 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.