From: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Connection's limit in SCO OpenServer 5.0.7 and pg 8.3.11 (no more than 94 connections) |
Date: | 2010-06-04 15:51:27 |
Message-ID: | 4C0920FF.1000607@sensacd.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello! I have postgres running on SCO OpenServer 5.0.7
and I've noticed that only accepts up to 94 connections, no more ...
I modified the values in postgresql.conf
max_connections from 100 to 128
shared_buffers from 24 to 48 MB
postgres is started with:
su - postgres -c "/usr/local/pgsql83/bin/postmaster -i -D
/usr/local/pgsql83/data"
I rebuilt the SCO kernel with these values:
NODE "srvr83"
EVDEVS 96
EVQUEUES 88
NSPTTYS 64
NUMSP 256
NSTREAM 4352
NHINODE 1024
GPGSLO 2000
GPGSHI 6000
NSTRPAGES 6000
NAIOPROC 50
NAIOREQ 400
NAIOBUF 400
NAIOHBUF 100
NAIOREQPP 400
NAIOLOCKTBL 50
MAX_PROC 10000
MAXUMEM 1048576
NCALL 256
NCLIST 512
NSTREVENT 14848
NUMTIM 1888
NUMTRW 1888
SDSKOUT 64
TTHOG 4096
SECLUID 0
SECSTOPIO 1
SECCLEARID 1
by the way the following variables have been established to the maximum
SEMMAP 8192
SEMMNI 8192
SEMMNS 8192
SEMMSL 300
SEMMNU 100
SHMMAX 2147483647
Any reply will be highly appreciated!
regards.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2010-06-04 16:10:08 | Re: How can I run an external program from a stored procedure? |
Previous Message | Tom Lane | 2010-06-04 15:23:35 | Re: cannot assign non-composite value to a row variable |