That makes sense, thanx. Another individual was having problems adjusting the shared_memory settings higher than 1.2GB on a 8GB 64bit machine running Vista. Whenever he would adjust higher than that, the postgresql service wouldn't start throwing some kind of error. In linux, one would simple adjust the SHMMAX settings. If there's no such setting in Windows, then the problem must lie somewhere else.

On a side, the docs could be a little more clear on this. (http://www.postgresql.org/docs/8.2/static/kernel-resources.html) The only reference to Windows says "(For the Windows port, PostgreSQL provides its own replacement implementation of these facilities)".

Cheers,
Kevin

Magnus Hagander wrote:
 > > 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 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to