From: | michel(dot)bellon(at)lcie(dot)fr |
---|---|
To: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Configuration under Win 2000 and cygwin (bug ?) |
Date: | 2002-03-14 16:26:21 |
Message-ID: | OF7FAB718B.A59CC9F0-ONC1256B7C.00531E4B@fr.bureauveritas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
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
Attachment | Content-Type | Size |
---|---|---|
=?iso-8859-1?Q?FORK=5FF~1.LOG?= | application/octet-stream | 38.9 KB |
=?iso-8859-1?Q?FATAL.LOG?= | application/octet-stream | 27.1 KB |
=?iso-8859-1?Q?POSTGR~1.CON?= | application/octet-stream | 3.1 KB |
=?iso-8859-1?Q?cygwin=5Fconf=5Fdiag.txt?= | text/plain | 15.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christophe FABRE | 2002-03-15 13:11:21 | scheduling tasks under cygwin |
Previous Message | Tim Finch, FosterFinch Ltd | 2002-03-14 12:06:37 | Re: Can't reload dump |