Re: Troubles with performances - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Troubles with performances
Date
Msg-id 3A68B108.5ABA5695@cupid.suninternet.com
Whole thread Raw
In response to RE: Troubles with performances  (Warren Vanichuk <pyber@street-light.com>)
List 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/

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: RE: Delete and self-join
Next
From: Stephan Szabo
Date:
Subject: Re: Delete and self-join