Lee Keel wrote: >> -----Original Message----- >> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- >> owner@xxxxxxxxxxxxxx] On Behalf Of Magnus Hagander >> Sent: Thursday, November 08, 2007 12:47 AM >> To: Tom Lane >> Cc: Kevin Neufeld; pgsql-general@xxxxxxxxxxxxxx >> Subject: Re: System V IPC on Windows >> >> > > 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 5: don't forget to increase your free space map settings > [Lee Keel] > > What if the page file exceeds the shared_buffers, but you can't increase the > shared buffers to a larger amount? For example, page file is set to be > between 500MB and 10GB, but you can't set the shared_buffers to more than > 1200MB. If set to 1300MB or higher then service will not start. Have you measured any performance at all on this? The general recommendation is to have a *small* shared_buffers on Widnows. >1Gb is likely way too large - try something much smaller unless you have benchmarks showing that this is helping you. //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
