Connections are through localhost. We've also connected via a client
machine through a router to insure it is not something on the server.
By drop connections, I mean Task Manager is showing additional
postgres.exe tasks after the completion of the test. Also, when we try
to drop the DB to reset for another test, PGAdmin reports connections.
Finally, of the 20 virtual users, any where from 2 to 12 or so will
successfully complete the test (by adding information to the DB via our
PHP app).
The postmaster can be shut down manually with no issues after the test.
However, upon rebooting the machine, I get IIS Helper Failed messages.
I don't know if this is related or not.
Logs don't really show anything. At least nothing I can find.
The only changes to the config file was to enable the logging at verbose
and info levels. I can send the file if you'd like to see it.
I've noticed a number of issues about beta releases dealing with sockets
and such. I haven't found anything indicating they were fixed or if
there are work arounds.
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Tuesday, January 24, 2006 3:09 AM
To: Carl Conard
Cc: Postgres User; Magnus Hagander; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2
Carl Conard wrote:
> I've successfully installed Postgres 8.1.2 on WS 2003 R2 on a Lenovo
> (IBM) ThinkPad. I used the default installation options and
everything
> seems peachy keen for a single user (using localhost).
>
> However, when we started performance testing Postgres (vs. MySQL)
using
> a 3rd party tool (I forget the name) running on the server, Postgres
> would drop connections after about the 10th or 11th virtual user (of
20)
> hit the DB. The remaining user processes would remain visible in
> Window's Task Manager and just "hang."
How are you connecting?
What do you mean by "drop connections"?
What do you mean by "hang" - does the server have problems shutting them
down if you tell it to?
What do the logs show?
What changes have you made to your configuration files?
--
Richard Huxton
Archonet Ltd
