Re: System V IPC on Windows

From: Lee Keel <lee(dot)keel(at)uai(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kevin Neufeld <kneufeld(at)refractions(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: System V IPC on Windows
Date: 2007-11-08 16:03:56
Message-ID: 76758090F8686C47A44B6FF52514A1D3092975AB@hermes.uai.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Magnus Hagander
> Sent: Thursday, November 08, 2007 12:47 AM
> To: Tom Lane
> Cc: Kevin Neufeld; pgsql-general(at)postgresql(dot)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.

Please see "GEOS union() error" thread for more details.

Thanks,
Lee
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Krasimir Hristozov (InterMedia Ltd) 2007-11-08 16:06:20 INSERT performance deteriorates quickly during a large import
Previous Message hubert depesz lubaczewski 2007-11-08 16:02:06 Re: why there is no interval / interval operator?