| From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
|---|---|
| To: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
| Cc: | Warren Vanichuk <pyber(at)street-light(dot)com>, "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Troubles with performances |
| Date: | 2001-01-19 21:26:32 |
| Message-ID: | 3A68B108.5ABA5695@cupid.suninternet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2001-01-19 21:31:46 | Re: Re: couple of general questions |
| Previous Message | Mike Mascari | 2001-01-19 21:21:29 | RE: Delete and self-join |