Re: System V IPC on Windows

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Kevin Neufeld <kneufeld(at)refractions(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: System V IPC on Windows
Date: 2007-11-08 19:30:29
Message-ID: 473363D5.8080903@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 memory etc. You're just not going
to fit that much in the address space.

There are fixes to reduce the memory usage of the postmaster (which is
likely what runs out first, unless you have a large work_mem) in 8.3,
but you're still right up against the wall with that large
shared_buffers. Plus, as I said in my other email, you're likely not
seeing any performance gain from such a large shared_buffers anyway. If
you are, you're seeing something new, and we definitely need to find out
why.

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lee Keel 2007-11-08 19:48:57 Re: System V IPC on Windows
Previous Message Magnus Hagander 2007-11-08 19:28:40 Re: System V IPC on Windows