Re: Installing Postgres 8.1 on Windows Server 2003 R2

From: Richard Huxton <dev(at)archonet(dot)com>
To: Carl Conard <CConard(at)nexgenisys(dot)com>
Cc: Postgres User <postgres(dot)user(at)gmail(dot)com>, Magnus Hagander <mha(at)sollentuna(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Installing Postgres 8.1 on Windows Server 2003 R2
Date: 2006-01-24 09:08:40
Message-ID: 43D5EE98.9060702@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sander Steffann 2006-01-24 09:10:34 Re: RAID 5 and postgresql
Previous Message Magnus Hagander 2006-01-24 09:04:43 Re: Does this look ethical to you?