Re: Troubles with performances
| От | Martijn van Oosterhout |
|---|---|
| Тема | Re: Troubles with performances |
| Дата | |
| Msg-id | 3A68B108.5ABA5695@cupid.suninternet.com обсуждение |
| Ответ на | RE: Troubles with performances (Warren Vanichuk <pyber@street-light.com>) |
| Список | 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 по дате отправления: