> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Magnus Hagander > Sent: Thursday, November 08, 2007 12:47 AM > To: Tom Lane > Cc: Kevin Neufeld; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
