Lee Keel wrote:
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
>> owner@postgresql.org] On Behalf Of Magnus Hagander
>> Sent: Thursday, November 08, 2007 12:47 AM
>> To: Tom Lane
>> Cc: Kevin Neufeld; pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] System V IPC on Windows
>>
>> > > Does anyone know how to adjust the IPC settings in Windows?
>>> There aren't any such settings in Windows, AFAIK.
>> Correct. The only real adjustable limit is the size of the Windows
>> pagefile, but that one is normally dynamic. But there must be room for all
>> the shared memory in it. It's not going to be there, but the space is
>> reserved.
>>
>> That said, if you need to increase the pagefile size to accomodate your
>> shared buffers, you likely have way too large value for shared buffers.
>>
>> /Magnus
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
> [Lee Keel]
>
> What if the page file exceeds the shared_buffers, but you can't increase the
> shared buffers to a larger amount? For example, page file is set to be
> between 500MB and 10GB, but you can't set the shared_buffers to more than
> 1200MB. If set to 1300MB or higher then service will not start.
Have you measured any performance at all on this? The general
recommendation is to have a *small* shared_buffers on Widnows. >1Gb is
likely way too large - try something much smaller unless you have
benchmarks showing that this is helping you.
//Magnus