Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Magnus Hagander
Lee Keel wrote: >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:pgsql-general- >> [EMAIL PROTECTED] On Behalf Of Magnus Hagander >> Sent: Thursday, November 08, 2007 1:30 PM >> To: Kevin Neufeld >> Cc: Tom Lane; pgsql-general@postgresql.org &g

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Lee Keel
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Magnus Hagander > Sent: Thursday, November 08, 2007 1:30 PM > To: Kevin Neufeld > Cc: Tom Lane; pgsql-general@postgresql.org > Subject: Re: [GENERAL] System V IPC

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Magnus Hagander
Kevin Neufeld wrote: > 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. Pg on win32 is 32-bit. It has a total address space of 2Gb, minus the OS overhead, minus the code, minus local me

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Magnus Hagander
Lee Keel wrote: >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:pgsql-general- >> [EMAIL PROTECTED] On Behalf Of Magnus Hagander >> Sent: Thursday, November 08, 2007 12:47 AM >> To: Tom Lane >> Cc: Kevin Neufeld; pgsql-general@postgresql.org &g

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Kevin Neufeld
> > 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. [Lee Keel] What if the page file exceeds the sh

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Kevin Neufeld
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 simpl

Re: [GENERAL] System V IPC on Windows

2007-11-08 Thread Lee Keel
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] 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] Sy

Re: [GENERAL] System V IPC on Windows

2007-11-07 Thread Magnus Hagander
> > 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

Re: [GENERAL] System V IPC on Windows

2007-11-07 Thread Tom Lane
Kevin Neufeld <[EMAIL PROTECTED]> writes: > Does anyone know how to adjust the IPC settings in Windows? There aren't any such settings in Windows, AFAIK. There's certainly not anything directly corresponding to SHMMAX, say. What have you run into that makes you think you need to adjust something