Re: postgres start problems with memory
От
Josh Close
Тема
Re: postgres start problems with memory
Дата
Msg-id
4a0cafe204093013507fc6c35f@mail.gmail.com
Ответ на
Re: postgres start problems with memory (Greg Stark)
Список
Дерево обсуждения
postgres start problems with memory Josh Close <narshe@gmail.com>
Re: postgres start problems with memory Josh Close <narshe@gmail.com>
Re: postgres start problems with memory Greg Stark <gsstark@mit.edu>
Re: postgres start problems with memory Josh Close <narshe@gmail.com>
On 30 Sep 2004 16:40:58 -0400, Greg Stark wrote: > > Josh Close writes: > > > To reduce the request size (currently 34037760 bytes), > ... > > root # sysctl -a | grep shm > > kernel.shmmni = 4096 > > kernel.shmall = 31584400 > > kernel.shmmax = 31584400 > > So it's currently looking for 34M and you're setting the maximum to 31M. > > -- > greg We'll, you're definitely right about that. Is there a certain standard to this? Say if I use the "reasonable value" formula. What would be a good size for the buffer then? Should it be a certain %age of available RAM? -Josh
В списке pgsql-general по дате отправления