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 majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
