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@xxxxxxxxxxxx] Sent: Tuesday, January 24, 2006 3:09 AM To: Carl Conard Cc: Postgres User; Magnus Hagander; pgsql-general@xxxxxxxxxxxxxx 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
