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@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:
+8525803 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
addresseeyou must not use or disclose such information, instead please report
ittoadmin@minerva.info<mailto:admin@minerva.info>
>>>> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 &
TheManifest 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:
+8525803 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
addresseeyou must not use or disclose such information, instead please report it
toadmin@minerva.info<mailto:admin@minerva.info>
>> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The
ManifestVoting 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
58031687 | 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
youmust 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
ManifestVoting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here
https://www.manifest.co.uk/legal/for further information.