Re: Kernel Resources and max_connections

От: Mark Kirkwood
Тема: Re: Kernel Resources and max_connections
Дата: ,
Msg-id: 42785AB4.5080206@paradise.net.nz
(см: обсуждение, исходный текст)
Ответ на: Re: Kernel Resources and max_connections  (Chris Hebrard)
Список: pgsql-performance

Скрыть дерево обсуждения

Kernel Resources and max_connections  (Chris Hebrard, )
 Re: Kernel Resources and max_connections  (Mark Kirkwood, )
  Re: Kernel Resources and max_connections  (Chris Hebrard, )
   Re: Kernel Resources and max_connections  (Mark Kirkwood, )
  Re: Kernel Resources and max_connections  ("Jim C. Nasby", )

Chris Hebrard wrote:
>
> I set the values in etc/sysctl.conf:
>
> # $FreeBSD: src/etc/sysctl.conf,v 1.1.2.3 2002/04/15 00:44:13 dougb Exp $
> #
> #  This file is read when going to multi-user and its contents piped thru
> #  ``sysctl'' to adjust kernel values.  ``man 5 sysctl.conf'' for details.
> #
> # Added by IMP 2005-05-04
> net.inet.tcp.rfc1323=1
> kern.ipc.somaxconn=1024
> kern.ipc.maxsockbuf=8388608
> net.inet.tcp.sendspace=3217968
> net.inet.tcp.recvspace=3217968
> kern.ipc.semmns="272"
> kern.ipc.semmni="256"
> kern.ipc.shmmax="66099200"
> kern.ipc.shmmin="256"
>
>
> After a restart both shmmax and shmmin are now 0 and postgres failed to
> start.
>
>
Hmmm - puzzling. One point to check, did you take them out of
/boot/loader.conf ?

Assuming so, maybe don't quote 'em (see below).

Finally you need to to set shmall, otherwise it will over(under)ride the
shmmax setting. So try:

net.inet.tcp.rfc1323=1
kern.ipc.somaxconn=1024
kern.ipc.maxsockbuf=8388608
net.inet.tcp.sendspace=3217968
net.inet.tcp.recvspace=3217968
kern.ipc.semmns=272
kern.ipc.semmni=256
kern.ipc.shmmax=66099200
kern.ipc.shmmin=256
kern.ipc.shmall=32768








В списке pgsql-performance по дате сообщения:

От: Mike Rylander
Дата:
Сообщение: Re:
От: "Mike G."
Дата:
Сообщение: Table stats