Hi all
I'am trying to tune a Windows 2000 system to support approximately 200
client.
In order to test the configuration, I'am using pgbench.
With this configuration (the complete file is joined)
max_connections = 200 # 1-1024
#port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777
#virtual_host = ''
#krb_server_keyfile = ''
#
# Performance
#
sort_mem = 512 # 512
shared_buffers = 30000 # 2*max_connections # min 16
#fsync = true
I'am unable to support more than ~25 to 30 client.
Two problems :
First) with pgbench -c80, one can see in the first log file after only 62
backend startup :
2002-03-14 14:22:22 [2544] DEBUG: CommitTransactionCommand
/usr/bin/postmaster: BackendStartup: fork failed: Resource temporarily
unavailable
Backend startup failed
pq_recvbuf: unexpected EOF on client connection
(See attached file: FORK_F~1.LOG)
second) with pgbench -c40, I have a crash with
2002-02-22 07:03:13 [1776] DEBUG: query: insert into
history(tid,bid,aid,delta,time) values(10,1,70266,193,'now')
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 2936 exited with status 0
FATAL: s_lock(0x1a4e0016) at spin.c:158, stuck spinlock. Aborting.
FATAL: s_lock(0x1a4e0016) at spin.c:158, stuck spinlock. Aborting.
Stack trace:
Frame Function Args
(See attached file: FATAL.LOG)
Here is my postgres configuration files
(See attached file: POSTGR~1.CON)
PostgreSQL 7.1.3
Cygwin described in (See attached file: cygwin_conf_diag.txt)
Michel BELLON
Direction Produits Méthodes Qualité
33 (0)1 40 95 60 35
http://www.lcie.fr
Cygwin Win95/NT Configuration Diagnostics
Current System Time: Fri Feb 22 18:02:22 2002
Windows 2000 Server Ver 5.0 Build 2195 Service Pack 2
Path: d:\cygwin\usr\local\bin
d:\cygwin\bin
d:\cygwin\bin
d:\cygwin\bin
d:\cygwin\bin
c:\WINNT\system32
c:\WINNT
c:\WINNT\System32\Wbem
c:\Resource Kit\
SysDir: C:\WINNT\System32
WinDir: C:\WINNT
HOME = `d:\cygwin\home\Administrateur'
MAKE_MODE = `unix'
PWD = `/home/Administrateur'
USER = `Administrateur'
ALLUSERSPROFILE = `C:\Documents and Settings\All Users'
APPDATA = `C:\Documents and Settings\Administrateur.DOM_LCIE\Application Data'
CLIENTNAME = `RAZANAKOTO'
COMMONPROGRAMFILES = `C:\Program Files\Fichiers communs'
COMPUTERNAME = `HESTIAW2K'
COMSPEC = `C:\WINNT\system32\cmd.exe'
HOMEDRIVE = `C:'
HOMEPATH = `\Documents and Settings\Administrateur.DOM_LCIE'
LOGONSERVER = `\\HERA'
MANPATH = `:/usr/ssl/man'
NUMBER_OF_PROCESSORS = `2'
OLDPWD = `/usr/bin'
OS2LIBPATH = `C:\WINNT\system32\os2\dll;'
OS = `Windows_NT'
PATHEXT = `.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
PROCESSOR_ARCHITECTURE = `x86'
PROCESSOR_IDENTIFIER = `x86 Family 6 Model 11 Stepping 1, GenuineIntel'
PROCESSOR_LEVEL = `6'
PROCESSOR_REVISION = `0b01'
PROGRAMFILES = `C:\Program Files'
PROMPT = `$P$G'
PS1 = `\[\033]0;\w\007
\033[32m\]\u@\h \[\033[33m\w\033[0m\]
$ '
SESSIONNAME = `RDP-Tcp#2'
SHLVL = `1'
SYSTEMDRIVE = `C:'
SYSTEMROOT = `C:\WINNT'
TEMP = `c:\DOCUME~1\ADMINI~1.DOM\LOCALS~1\Temp'
TERM = `cygwin'
TMP = `c:\DOCUME~1\ADMINI~1.DOM\LOCALS~1\Temp'
USERDOMAIN = `DOM_LCIE'
USERNAME = `Administrateur'
USERPROFILE = `C:\Documents and Settings\Administrateur.DOM_LCIE'
WINDIR = `C:\WINNT'
_ = `/usr/bin/cygcheck'
HKEY_CURRENT_USER\Software\Cygnus Solutions
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin
(default) = 0x00000350
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2
(default) = `/cygdrive'
cygdrive flags = 0x00000020
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/
(default) = `d:/cygwin'
flags = 0x00000008
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin
(default) = `d:/cygwin/bin'
flags = 0x00000008
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib
(default) = `d:/cygwin/lib'
flags = 0x00000008
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options
a: fd N/A N/A
c: hd NTFS 5000Mb 55% CP CS UN PA FC
d: hd NTFS 64417Mb 5% CP CS UN PA FC Nouveau nom
e: cd N/A N/A
m: net NTFS 36847Mb 69% CP CS UN PA FC
. /cygdrive user textmode,noumount
d:/cygwin / system textmode
d:/cygwin/bin /usr/bin system textmode
d:/cygwin/lib /usr/lib system textmode
Found: d:\cygwin\bin\bash.exe
Found: d:\cygwin\bin\cat.exe
Found: d:\cygwin\bin\cpp.exe
Found: d:\cygwin\bin\find.exe
Found: d:\cygwin\bin\gcc.exe
Found: d:\cygwin\bin\gdb.exe
Found: d:\cygwin\bin\ld.exe
Found: d:\cygwin\bin\ls.exe
Found: d:\cygwin\bin\make.exe
Found: d:\cygwin\bin\sh.exe
751k 2002/01/21 d:\cygwin\usr\local\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
"cygwin1.dll" v0.0 ts=2002/1/21 18:48
Cygwin DLL version info:
DLL version: 1.3.9
DLL epoch: 19
DLL bad signal mask: 19005
DLL old termios: 5
DLL malloc env: 28
API major: 0
API minor: 51
Shared data: 3
DLL identifier: cygwin1
Mount registry: 2
Cygnus registry name: Cygnus Solutions
Cygwin registry name: Cygwin
Program options name: Program Options
Cygwin mount registry name: mounts v2
Cygdrive flags: cygdrive flags
Cygdrive prefix: cygdrive prefix
Cygdrive default prefix:
Build date: Mon Jan 21 12:48:41 EST 2002
Shared id: cygwin1S3
56k 2000/12/03 d:\cygwin\bin\cygbz21.0.dll - os=4.0 img=1.0 sys=4.0
"cygbz21.0.dll" v0.0 ts=2000/11/21 0:53
621k 2002/01/16 d:\cygwin\bin\cygcrypto.dll - os=4.0 img=1.0 sys=4.0
"cygcrypto.dll" v0.0 ts=2002/1/16 10:54
107k 2002/01/23 d:\cygwin\bin\cygcurl-2.dll - os=4.0 img=1.0 sys=4.0
"cygcurl-2.dll" v0.0 ts=2002/1/23 19:25
73k 2002/01/16 d:\cygwin\bin\cygexslt-0.dll - os=4.0 img=1.0 sys=4.0
"cygexslt-0.dll" v0.0 ts=2002/1/16 10:06
45k 2001/04/25 d:\cygwin\bin\cygform5.dll - os=4.0 img=1.0 sys=4.0
"cygform5.dll" v0.0 ts=2001/4/25 7:28
35k 2002/01/09 d:\cygwin\bin\cygform6.dll - os=4.0 img=1.0 sys=4.0
"cygform6.dll" v0.0 ts=2002/1/9 7:03
18k 2000/10/23 d:\cygwin\bin\cyggdbm.dll - os=4.0 img=1.0 sys=4.0
"cyggdbm.dll" v0.0 ts=2000/10/23 4:26
17k 2001/06/28 d:\cygwin\bin\cyghistory4.dll - os=4.0 img=1.0 sys=4.0
"cyghistory4.dll" v0.0 ts=2001/1/7 5:34
20k 2002/01/13 d:\cygwin\bin\cyghistory5.dll - os=4.0 img=1.0 sys=4.0
"cyghistory5.dll" v0.0 ts=2002/1/13 2:27
22k 2001/12/13 d:\cygwin\bin\cygintl-1.dll - os=4.0 img=1.0 sys=4.0
"cygintl-1.dll" v0.0 ts=2001/12/13 10:28
81k 2001/10/20 d:\cygwin\bin\cygitcl30.dll - os=4.0 img=1.0 sys=4.0
"cygitcl30.dll" v0.0 ts=2001/10/20 2:25
35k 2001/10/20 d:\cygwin\bin\cygitk30.dll - os=4.0 img=1.0 sys=4.0
"cygitk30.dll" v0.0 ts=2001/10/20 2:25
45k 2002/02/08 d:\cygwin\bin\cygjbig1.dll - os=4.0 img=1.0 sys=4.0
"cygjbig1.dll" v0.0 ts=2002/2/8 0:59
119k 2002/02/09 d:\cygwin\bin\cygjpeg6b.dll - os=4.0 img=1.0 sys=4.0
"cygjpeg6b.dll" v0.0 ts=2002/2/9 6:19
35k 2002/02/04 d:\cygwin\bin\cygltdl-3.dll - os=4.0 img=1.0 sys=4.0
"cygltdl-3.dll" v0.0 ts=2002/2/4 2:56
26k 2001/04/25 d:\cygwin\bin\cygmenu5.dll - os=4.0 img=1.0 sys=4.0
"cygmenu5.dll" v0.0 ts=2001/4/25 7:27
20k 2002/01/09 d:\cygwin\bin\cygmenu6.dll - os=4.0 img=1.0 sys=4.0
"cygmenu6.dll" v0.0 ts=2002/1/9 7:03
156k 2001/04/25 d:\cygwin\bin\cygncurses++5.dll - os=4.0 img=1.0 sys=4.0
"cygncurses++5.dll" v0.0 ts=2001/4/25 7:29
175k 2002/01/09 d:\cygwin\bin\cygncurses++6.dll - os=4.0 img=1.0 sys=4.0
"cygncurses++6.dll" v0.0 ts=2002/1/9 7:03
226k 2001/04/25 d:\cygwin\bin\cygncurses5.dll - os=4.0 img=1.0 sys=4.0
"cygncurses5.dll" v0.0 ts=2001/4/25 7:17
202k 2002/01/09 d:\cygwin\bin\cygncurses6.dll - os=4.0 img=1.0 sys=4.0
"cygncurses6.dll" v0.0 ts=2002/1/9 7:03
15k 2001/04/25 d:\cygwin\bin\cygpanel5.dll - os=4.0 img=1.0 sys=4.0
"cygpanel5.dll" v0.0 ts=2001/4/25 7:27
12k 2002/01/09 d:\cygwin\bin\cygpanel6.dll - os=4.0 img=1.0 sys=4.0
"cygpanel6.dll" v0.0 ts=2002/1/9 7:03
40k 2001/11/21 d:\cygwin\bin\cygpcre.dll - os=4.0 img=1.0 sys=4.0
"cygpcre.dll" v0.0 ts=2001/11/21 23:15
39k 2001/11/21 d:\cygwin\bin\cygpcreposix.dll - os=4.0 img=1.0 sys=4.0
"cygpcreposix.dll" v0.0 ts=2001/11/21 23:15
108k 2001/06/28 d:\cygwin\bin\cygreadline4.dll - os=4.0 img=1.0 sys=4.0
"cygreadline4.dll" v0.0 ts=2001/1/7 5:34
121k 2002/01/13 d:\cygwin\bin\cygreadline5.dll - os=4.0 img=1.0 sys=4.0
"cygreadline5.dll" v0.0 ts=2002/1/13 2:27
66k 2001/11/20 d:\cygwin\bin\cygregex.dll - os=4.0 img=1.0 sys=4.0
"cygregex.dll" v0.0 ts=2001/11/20 15:44
156k 2002/01/16 d:\cygwin\bin\cygssl.dll - os=4.0 img=1.0 sys=4.0
"cygssl.dll" v0.0 ts=2002/1/16 10:54
390k 2001/10/20 d:\cygwin\bin\cygtcl80.dll - os=4.0 img=1.0 sys=4.0
"cygtcl80.dll" v0.0 ts=2001/10/20 2:24
5k 2001/10/20 d:\cygwin\bin\cygtclpip80.dll - os=4.0 img=1.0 sys=4.0
10k 2001/10/20 d:\cygwin\bin\cygtclreg80.dll - os=4.0 img=1.0 sys=4.0
"cygtclreg80.dll" v0.0 ts=2001/10/20 2:24
253k 2002/02/10 d:\cygwin\bin\cygtiff3.dll - os=4.0 img=1.0 sys=4.0
"cygtiff3.dll" v0.0 ts=2002/2/10 9:34
623k 2001/10/20 d:\cygwin\bin\cygtk80.dll - os=4.0 img=1.0 sys=4.0
"cygtk80.dll" v0.0 ts=2001/10/20 2:25
612k 2002/01/16 d:\cygwin\bin\cygxml2-2.dll - os=4.0 img=1.0 sys=4.0
"cygxml2-2.dll" v0.0 ts=2002/1/16 5:24
41k 2001/07/04 d:\cygwin\bin\cygXpm-noX4.dll - os=4.0 img=1.0 sys=4.0
"cygXpm-noX4.dll" v0.0 ts=2001/7/4 3:21
45k 2001/07/04 d:\cygwin\bin\cygXpm-X4.dll - os=4.0 img=1.0 sys=4.0
"cygXpm-X4.dll" v0.0 ts=2000/11/20 3:45
202k 2002/01/16 d:\cygwin\bin\cygxslt-1.dll - os=4.0 img=1.0 sys=4.0
"cygxslt-1.dll" v0.0 ts=2002/1/16 9:52
22k 2002/01/16 d:\cygwin\bin\cygxsltbreakpoint-1.dll - os=4.0 img=1.0 sys=4.0
"cygxsltbreakpoint-1.dll" v0.0 ts=2002/1/16 10:05
50k 2002/01/20 d:\cygwin\bin\cygz.dll - os=4.0 img=1.0 sys=4.0
"cygz.dll" v0.0 ts=2002/1/20 20:41
751k 2002/01/21 d:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
"cygwin1.dll" v0.0 ts=2002/1/21 18:48
Cygwin DLL version info:
DLL version: 1.3.9
DLL epoch: 19
DLL bad signal mask: 19005
DLL old termios: 5
DLL malloc env: 28
API major: 0
API minor: 51
Shared data: 3
DLL identifier: cygwin1
Mount registry: 2
Cygnus registry name: Cygnus Solutions
Cygwin registry name: Cygwin
Program options name: Program Options
Cygwin mount registry name: mounts v2
Cygdrive flags: cygdrive flags
Cygdrive prefix: cygdrive prefix
Cygdrive default prefix:
Build date: Mon Jan 21 12:48:41 EST 2002
Shared id: cygwin1S3
Cygwin Package Information
Last downloaded files to: d:\cygwin\lpd
Last downloaded files from: ftp://ftp.ccp14.dl.ac.uk/ccp14/ftp-mirror/programming/cygwin/pub/cygwin
Package Version
ash 20020131-1
autoconf 2.52a-1
autoconf-devel 2.52-4
autoconf-stable 2.13-4
automake 1.5b-1
automake-devel 1.5-5
automake-stable 1.4p5-5
bash 2.05a-2
bc 1.06-1
binutils 20011002-1
bison 1.33-1
byacc 1.9-1
bzip2 1.0.1-6
clear 1.0
compface 1.4-5
cpio 2.4.2
cron 3.0.1-5
crypt 1.0-1
ctags 5.2-1
curl 7.9.3-1
cvs 1.11.0-1
cygrunsrv 0.94-2
cygutils 0.9.8-1
cygwin 1.3.9-1
dejagnu 20010117-1
diff 0.0
ed 0.2-1
expect 20010117-1
figlet 2.2-1
file 3.37-1
fileutils 4.1-1
findutils 4.1
flex 2.5.4-1
gawk 3.0.4-1
gcc 2.95.3-5
gdb 20010428-3
gdbm 1.8.0-3
gettext 0.10.40-1
ghostscript 6.51-1
gperf 0.0
grep 2.4.2-1
groff 1.17.2-1
gzip 1.3.2-1
indent 2.2.7-2
inetutils 1.3.2-17
irc 20010101-1
jbigkit 1.2-6
jpeg 6b-7
less 358-3
libintl 0.10.38-3
libintl1 0.10.40-1
libncurses5 5.2-1
libncurses6 5.2-8
libpng 1.0.12-1
libpng2 1.0.12-1
libreadline4 4.1-2
libreadline5 4.2a-1
libtool 20010531a-1
libtool-devel 20020202-1
libtool-stable 1.4.2-2
libxml2 2.4.13-1
libxslt 1.0.10-1
links 0.96-1
login 1.4-3
m4 0.0
make 3.79.1-5
man 1.5g-2
mingw-runtime 1.2-1
mktemp 1.4-1
mutt 1.2.5i-6
ncftp 3.0.2-2
ncurses 5.2-8
newlib-man 20001118-1
opengl 1.1.0-5
openssh 3.0.2p1-5
openssl 0.9.6c-3
openssl-devel 0.9.6c-2
patch 2.5-2
pcre 3.7-1
perl 5.6.1-2
popt 1.6.2-1
postgresql 7.1.3-2
python 2.2-1
rcs 5.7-2
readline 4.2a-1
regex 4.4-2
rsync 2.5.2-1
sed 3.02-1
sh-utils 2.0-2
sharutils 4.2.1-2
shutdown 1.2-2
squid 2.4-STABLE20010508
ssmtp 2.38.7-3
tar 1.13.19-1
tcltk 20001125-1
tcsh 6.11.00-3
termcap 20010825-1
terminfo 5.2-1
tetex-beta 20001218-1
texinfo 4.0-5
texmf 20000804-2
texmf-base 20000804-2
texmf-doc 20000804-2
texmf-extra 20000804-2
texmf-tiny 20000804-2
textutils 2.0.16-1
tiff 3.5.7-1
time 1.7-1
units 1.77-1
unzip 5.41-1
vim 6.0.93-1
w32api 1.2-1
wget 1.8-1
which 1.5-1
whois 4.5.17-1
xpm-nox 4.1.0-1
zip 2.3-1
zlib 1.1.3-7
Use -h to see help about each section