Horton

Re: Troubles with performances

Martijn van Oosterhout <kleptog@cupid.suninternet.com>

View thread View on postgr.es
From: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
To: Lamar Owen <lamar.owen@wgcr.org>
Cc: Warren Vanichuk <pyber@street-light.com>, "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>, pgsql-general <pgsql-general@postgresql.org>
Date: 2001-01-19T21:26:32Z
Lists: pgsql-general 
Lamar Owen wrote:
> 
> Warren Vanichuk wrote:
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=143193088, permission=600
> 
> > -o -F -B 2048 -N 512 -S 4096
> 
> Ok, you have 2048 8K buffers, and up to 512 backends.  If you're trying
> to set SortSize to 4096, you need quotes around it and a -o, AFAIK, asx
> the -S postmaster option sets silent mode.
> 
> Further along,
> 
> According to the shmget man page:
> 
[snip]

I think these are the ones you're looking for:

kleptog/~>grep . `find /proc/sys -name '*shm*'`
/proc/sys/kernel/shmall:4194304
/proc/sys/kernel/shmmax:33554432

Just echo new values into there to change them...
-- 
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/