Re: Performance on 8CPU's and 32GB of RAM - Mailing list pgsql-performance

From James Mansion
Subject Re: Performance on 8CPU's and 32GB of RAM
Date
Msg-id 46E0657E.30401@mansionfamily.plus.com
Whole thread Raw
In response to Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Performance on 8CPU's and 32GB of RAM
Re: Performance on 8CPU's and 32GB of RAM
List pgsql-performance
Scott Marlowe wrote:
> Where unixes generally outperform windows is in starting up new
> backends, better file systems, and handling very large shared_buffer
> settings.
>

Why do you think that UNIX systems are better at handling large shared
buffers than Wndows?
32 bit Windows systems can suffer from fragmented address space, to be
sure, but if the
performance of the operating-system supplied mutex or semaphore isn't
good enough, you can
just use the raw atomic ops.

If what you mean is that pg has a design that's heavily oriented towards
things that tend to
be cheap on POSIX and doesn't use the core Win32 features effectively,
then let's track
that as an optimisation opportunity for the Win32 port.


pgsql-performance by date:

Previous
From: James Mansion
Date:
Subject: Re: Performance on 8CPU's and 32GB of RAM
Next
From: "Scott Marlowe"
Date:
Subject: Re: Performance on 8CPU's and 32GB of RAM