Re: Windows performance - Mailing list pgsql-general

From George Neuner
Subject Re: Windows performance
Date
Msg-id 1892cbdpufd1mj589dtq2pjvopef931qei@4ax.com
Whole thread Raw
In response to Windows performance  ("Sterpu Victor" <victor@caido.ro>)
List pgsql-general
On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce
<pierce@hogranch.com> wrote:

>On 2/12/2016 2:28 PM, George Neuner wrote:
>> In Linux the distinction between a "workstation" and a "server" is
>> largely a matter of system configuration.  Windows "desktop" and
>> "server" editions are different code bases: there are no magic
>> settings that can make one equivalent to the other.
>
>thats not actually true, the kernels are built from the same code base,

Technicality: the "code base" may be the same but the _code_ is not.

Corresponding[*] desktop and server editions install different code
for a number of key modules.  This is easily verified by comparing the
installations.

[*] server 2008  <>  windows 7
     server 2012  <>  windows 8

Haven't seen server 2016 yet.

>but there are internal settings that change the behavior defaults in the
>scheduler, like prioritizing services vs the desktop.   these settings
>have been obfuscated, at one time you could tweak them in the registry.

You still can tweak a great many things IFF you know how.  But it
isn't (and never was) possible to tweak a desktop into a server.

George

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Optimize Query
Next
From: Augori
Date:
Subject: Re: Trouble installing PostGIS on Amazon Linux server