Rick Apichairuk wrote:
On Sun, 30 Jan 2005 21:12:08 -0500, Sven Willenberger <[EMAIL PROTECTED]> wrote:
I assume you added these variables to either the GENERIC or a custom
kernel in /usr/src/sys/i386/conf. If you created a custom kernel called
CUSTOM, then you would:
That's what I did.
cd /u
On Sun, 30 Jan 2005 21:12:08 -0500, Sven Willenberger <[EMAIL PROTECTED]> wrote:
> I assume you added these variables to either the GENERIC or a custom
> kernel in /usr/src/sys/i386/conf. If you created a custom kernel called
> CUSTOM, then you would:
That's what I did.
> cd /usr/src
> make bui
Rick Apichairuk wrote:
I tried the settings you gave and they worked (with some caveats).
After I recompiled the FreeBSD kernel with the options:
options SYSVSHM
options SYSVMSG
options SYSVSEM
options SHMMAXPGS=131072
options SEMMNI=128
options SEMM
I tried the settings you gave and they worked (with some caveats).
After I recompiled the FreeBSD kernel with the options:
options SYSVSHM
options SYSVMSG
options SYSVSEM
options SHMMAXPGS=131072
options SEMMNI=128
options SEMMNS=512
options
I've tested this up to 250 connections on 5.3:
options SHMMAXPGS=131072
options SEMMNI=128
options SEMMNS=512
options SEMUME=100
options SEMMNU=256
---(end of broadcast)---
TIP 2: you can get off all lists at
On Sun, Jan 30, 2005 at 04:26:29PM -0500, Rick Apichairuk wrote:
> Is the shared_buffers per process? The reason I ask is the formula
> given on http://www.postgresql.org/docs/7.4/static/kernel-resources.html
> for calculating how much SHMMAX you need is:
>
> SHMMAX = 250 kB + 8.2 kB * shared_buff
On Sun, 30 Jan 2005 20:50:21 +, Richard Poole <[EMAIL PROTECTED]> wrote:
> On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
>
> > I am trying to increase the number of max_connections to 200 and found
> > out I couldn't even start postgresql. So I tried to increase
> > max_conn
On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
> This is confusing because the requested size is both higher than
> SHMMIN and lower than SHMMAX as you can see below:
Maybe your problem is shmall:
> [ [EMAIL PROTECTED] ] $ sysctl -a | grep kern.ipc
> kern.ipc.shmmax: 33554432
Rick Apichairuk <[EMAIL PROTECTED]> writes:
> This is confusing because the requested size is both higher than
> SHMMIN and lower than SHMMAX as you can see below:
SHMALL is the other limit that might cause this failure.
regards, tom lane
---(end
On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
> I am trying to increase the number of max_connections to 200 and found
> out I couldn't even start postgresql. So I tried to increase
> max_connections gradually (currently at 50 from 40 default) and adjust
> shared memory settings
Greetings,
I am trying to increase the number of max_connections to 200 and found
out I couldn't even start postgresql. So I tried to increase
max_connections gradually (currently at 50 from 40 default) and adjust
shared memory settings along the way. Even at 50 max_connections, I
still cannot get
11 matches
Mail list logo
