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 по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: RE: Delete and self-join
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Delete and self-join