> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Magnus Hagander > Sent: Thursday, November 08, 2007 1:30 PM > To: Kevin Neufeld > Cc: Tom Lane; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: System V IPC on Windows > > 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 > > [Lee Keel] I can't do any benchmarks because I keep getting errors. But I have dropped this value down and I am not getting the out of memory errors any more. I was trying to solve other problems by bumping this way up but it seemed to just cause more problems. I found several things in documentation that says that bumping the shared_buffers\work_mem up to over 1gb was fine. Is that strictly for linux boxes? -LK 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
