Configuration under Win 2000 and cygwin (bug ?)

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

Responses

Browse pgsql-cygwin by date

  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