Skip site navigation (1) Skip section navigation (2)

Re: Windows shared_buffers limitations

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Windows shared_buffers limitations
Date: 2008-03-27 16:02:12
Message-ID: 7pgnu31pmmf86q8fdflmeagv8ae1k4veaq@4ax.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Smith wrote:

>Was working on some documentation today and I realized that I've taken for 
>granted the lore about not using large values for shared_buffers in 
>Windows without ever understanding why.  Can someone explain what the 
>underlying mechanism that causes that limitation is?  From poking the 
>archives I got the impression it was some page mapping issue but details 
>are elusive.

All I can offer is Magnus' explanation: "All evidence I've seen points to that
you should have shared_buffers as *small* as possible on win32, because memory
access there is slow. And leave more of the caching up to the OS."
<http://archives.postgresql.org/pgsql-general/2007-10/msg01115.php>

Heikki said something similar here:
<http://archives.postgresql.org/pgsql-performance/2007-10/msg00242.php>

Rainer

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-03-27 16:18:42
Subject: Re: Patch queue permenent URLs
Previous:From: Dave PageDate: 2008-03-27 15:54:01
Subject: Re: Patch queue permenent URLs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group