Обсуждение: Shared Memory
Hi all, I have tried to give PostGres a little more shared memory but I failed. I'm running Linux 2.4.9-13 (RedHat 7.2 + all the updates). I currently have 2048 blocks (8K each) allocated, when I try to push this up to 3072 or higher, I get IpcMemoryCreate: shmget(key=5432001, size=43540480, 03600) failed: Invalid argument and a log story about SHMMAX - Now, I have checked where ever I can and found, that the max is about 16 MB in an unmodified kernel. My question: How do I increase that without the need of a kernel re-compile? Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
On Saturday 15 December 2001 10:01 pm, Chris Ruprecht wrote: > IpcMemoryCreate: shmget(key=5432001, size=43540480, 03600) failed: > Invalid argument > and a log story about SHMMAX - Now, I have checked where ever I can > and found, that the max is about 16 MB in an unmodified kernel. My > question: How do I increase that without the need of a kernel > re-compile? See the kernel sysctl docs for /proc/sys/kernel/shmmax -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Chris: The quick answer is here- a little more than halfway down the page. http://www.postgresql.org/idocs/index.php?kernel-resources.html Regards, -Nick > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Chris Ruprecht > Sent: Saturday, December 15, 2001 10:01 PM > To: PostGreSQL Admin Group > Subject: [ADMIN] Shared Memory > > > Hi all, > > I have tried to give PostGres a little more shared memory but I > failed. I'm running Linux 2.4.9-13 (RedHat 7.2 + all the updates). I > currently have 2048 blocks (8K each) allocated, when I try to push > this up to 3072 or higher, I get > IpcMemoryCreate: shmget(key=5432001, size=43540480, 03600) failed: > Invalid argument > and a log story about SHMMAX - Now, I have checked where ever I can > and found, that the max is about 16 MB in an unmodified kernel. My > question: How do I increase that without the need of a kernel > re-compile? > > Best regards, > Chris > -- > Chris Ruprecht > Network grunt and bit pusher extraordinaíre > _________________________________________________________ Do You > Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Thank you guys - I have the answer and it's ticking along nicely now with 68888 KB of shared memory (this is what 'top' reports). I have set the parameter in the config file to 8192, now I have to monitor if this has any impact on speed. Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com