Re: Increasing Max Connections Mac OS 10.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Increasing Max Connections Mac OS 10.3
Дата
Msg-id 21637.1076349877@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Increasing Max Connections Mac OS 10.3  (Joe Lester <joe_lester@sweetwater.com>)
Ответы Re: Increasing Max Connections Mac OS 10.3  (Joe Lester <joe_lester@sweetwater.com>)
Список pgsql-general
Joe Lester <joe_lester@sweetwater.com> writes:
> I installed Postgres 7.4.1 on a dual processor G5 running Mac OS
> 10.3.2. I'm trying to increase the max_connections to 300 and running
> into some trouble.

Hmm, it WorksForMe (TM).  You did reboot after changing /etc/rc, no?
Try "sysctl -a | grep sysv" to verify that the settings took effect.

Note that there's not much percentage in setting shmmax higher than
shmall * pagesize.  I see hw.pagesize = 4096 according to sysctl,
which means your shmall=65536 constrains the total allocation to 256MB,
so setting shmmax to 500M doesn't do anything...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Joshua Drake
Дата:
Сообщение: Re: Quad Xeon vs. Dual Itanium
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Quad Xeon vs. Dual Itanium