From gibon@comexsystem.com.br Wed Aug  25 02:12:25 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3440563325D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 24 Aug 2010 23:12:25 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 14562-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 02:12:18 +0000 (UTC)
X-Greylist: delayed 00:06:40.566411 by SQLgrey-1.7.6
Received: from ns3b.twi.com.br (ns3b.twi.com.br [201.87.225.54])
	by mail.postgresql.org (Postfix) with ESMTP id 98C3363244B
	for <pgsql-admin@postgresql.org>; Tue, 24 Aug 2010 23:12:17 -0300 (ADT)
Received: (qmail 71333 invoked from network); 24 Aug 2010 23:04:02 -0300
Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[201.21.98.184])
	(envelope-sender <gibon@comexsystem.com.br>)
	by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP
	for <pgsql-admin@postgresql.org>; 24 Aug 2010 23:04:02 -0300
Message-ID: <004a01cb43f9$ffb46040$6500a8c0@gibon>
Reply-To: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
From: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
To: "PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
Subject: PostgreSQL 8.4 x Win 2008  - slow connection
Date: Tue, 24 Aug 2010 23:05:22 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0047_01CB43E0.D4A612E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201008/203
X-Sequence-Number: 35452

This is a multi-part message in MIME format.

------=_NextPart_000_0047_01CB43E0.D4A612E0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I'm having problems with connection time using Post 8.4 on Win 2008 =
enterprise (32bits). To do open/close 10 connections i lost about 20 =
seconds and doing the same test using Post 8.4 in another server (Win =
2003) on 20 seconds i get (open/close) almost 500 connections. The =
difference is very very large. Somebody did have any problem like this?

Some tip is very well!!!

thanks

F=E1bio Henrique Gibon
------=_NextPart_000_0047_01CB43E0.D4A612E0
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252"><BASE=20
href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">
<STYLE></STYLE>

<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR></HEAD>
<BODY background=3D"">
<DIV>I'm having problems with connection time using Post 8.4 on Win 2008 =

enterprise (32bits). To do open/close 10 connections i lost about 20 =
seconds and=20
doing the same test using Post 8.4 in another server (Win 2003) on 20 =
seconds i=20
get (open/close) almost 500 connections. The difference is very very =
large.=20
Somebody did have any problem like this?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Some tip is very well!!!</DIV>
<DIV>&nbsp;</DIV>
<DIV>thanks</DIV>
<DIV><BR>F=E1bio Henrique Gibon</DIV></BODY></HTML>

------=_NextPart_000_0047_01CB43E0.D4A612E0--




From scott.marlowe@gmail.com Wed Aug  25 03:48:41 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 1532D6342DC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 00:48:41 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 31390-02-2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 03:48:33 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com
 [74.125.82.50])
	by mail.postgresql.org (Postfix) with ESMTP id 81298635E13
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 00:44:42 -0300 (ADT)
Received: by wwb13 with SMTP id 13so279606wwb.19
	for <pgsql-admin@postgresql.org>; Tue, 24 Aug 2010 20:44:41 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=2o3l1ldARmot/9WQZZZVIU5YaorDwY2HiNZva//6rdw=;
	b=nXCfYdWt0+Uv7kjU+0658Wvn5P5Sf/5pkKPjpO4ZxSw4xwoBQ1dfz8nl6fo+2pipC9
	riqT1LclTjt0lA662YxfqKUc6xD+HXOFfFHvFfFxtE+z8MW5g6eVXijTN67elP1lI4Sl
	NgovECm44sGYa93xSXoWx9ztQk4eZMbWqV0qQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=eWDY+C8YPfP0LAdH1ElfqSzZ+pXBduRlqMUe47nucL7pzNCcIrAI0mlpplyDVZFPo0
	I0ikBWqSKL/058YzpJnO2rZ0sptTwYiF0HNNqtSxLVzlM1P2uaUNJm74vL6nUzo15dv+
	Ums0kr+jtrlV2MlP7fjaYmG3KmZPWN5Jfj2Uo=
MIME-Version: 1.0
Received: by 10.227.28.223 with SMTP id n31mr6561323wbc.174.1282707881138;
	Tue, 24 Aug 2010 20:44:41 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Tue, 24 Aug 2010 20:44:41 -0700 (PDT)
In-Reply-To: <004a01cb43f9$ffb46040$6500a8c0@gibon>
References: <004a01cb43f9$ffb46040$6500a8c0@gibon>
Date: Tue, 24 Aug 2010 21:44:41 -0600
Message-ID: <AANLkTikZhPzaFCGp_xDog5+w_zOiYoBqrr+rhgL+zvMo@mail.gmail.com>
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
From: Scott Marlowe <scott.marlowe@gmail.com>
To: =?ISO-8859-1?Q?F=E1bio_Gibon_=2D_Comex_System?= <gibon@comexsystem.com.br>
Cc: PostgreSQL - mailing list <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/206
X-Sequence-Number: 35455

On Tue, Aug 24, 2010 at 8:05 PM, F=E1bio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> I'm having problems with connection time using Post 8.4 on Win 2008
> enterprise (32bits). To do open/close 10 connections i lost about 20 seco=
nds
> and doing the same test using Post 8.4 in another server (Win 2003) on 20
> seconds i get (open/close) almost 500 connections. The difference is very
> very large. Somebody did have any problem like this?

I'm no windows guru, but I'd bet on some kind of windows congestion
control in the networking stack trying to be "helpful" and botching
the job.



From scott.marlowe@gmail.com Wed Aug  25 17:07:03 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 02ADF632BEF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 14:07:03 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 88456-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 17:06:54 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com
 [74.125.82.50])
	by mail.postgresql.org (Postfix) with ESMTP id 7EBB6632AAD
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 14:06:54 -0300 (ADT)
Received: by wwb13 with SMTP id 13so1146750wwb.19
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 10:06:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:content-type
	:content-transfer-encoding;
	bh=33d11SbRx4b0mUqSH27yv2M80cUwM0bfzOZHpzvC6Lw=;
	b=uE2liwhvMBCDKeTuJ4F1GmgHkTb50cmwqT5MRSxNxlxzjW+WGbzDa+WFkz6PqwTRIT
	QgJkIUNdOJ0qYwYkMTmFOCbgsa1CUqqzhRoa4N7NpK/GuYh3jJP9E7fW9cUhMr9MFigZ
	UP/8HXk+WU1TEko6q9bz9yDABnnNsyy/qNFeQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type:content-transfer-encoding;
	b=f0VZS+ty08GA4vqTnLkoU7g11JLB6uuqFKBVbWg7PZjMwrWSsOPaIgsutD8u6aFwos
	D6Zd/JJjfOIDgXQKzAzNTIM5TIRUUuoFuMUu/BwAjbTxgepUgkvrOiPWvsH/M1kpNm6l
	VY5hOQRhUsjmkDB0BfjnYTG/xTptHH9F34l+M=
MIME-Version: 1.0
Received: by 10.227.28.223 with SMTP id n31mr7322689wbc.174.1282756012939;
	Wed, 25 Aug 2010 10:06:52 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Wed, 25 Aug 2010 10:06:52 -0700 (PDT)
In-Reply-To: <009001cb4450$24a00390$6500a8c0@gibon>
References: <004a01cb43f9$ffb46040$6500a8c0@gibon>
	<AANLkTikZhPzaFCGp_xDog5+w_zOiYoBqrr+rhgL+zvMo@mail.gmail.com>
	<009001cb4450$24a00390$6500a8c0@gibon>
Date: Wed, 25 Aug 2010 11:06:52 -0600
Message-ID: <AANLkTimcTRwOHf-pNbdWxR2_qqtjFU=3UCNZy2-KfdXr@mail.gmail.com>
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
From: Scott Marlowe <scott.marlowe@gmail.com>
To: =?ISO-8859-1?Q?F=E1bio_Gibon_=2D_Comex_System?=
 <gibon@comexsystem.com.br>,
	pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.5 tagged_above=-10 required=5 tests=BAYES_05=-0.5,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/221
X-Sequence-Number: 35470

Please keep the list cc'd to your replies

On Wed, Aug 25, 2010 at 6:22 AM, F=E1bio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> Tks Scott...
> =A0 =A0 =A0 =A0but I did tests connecting by network and local, both was =
very
> slowly.

That in no way proves it's not a network problem.



From scott.marlowe@gmail.com Wed Aug  25 20:54:20 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 982EA63314D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 17:54:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 52317-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 20:54:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com
 [74.125.82.50])
	by mail.postgresql.org (Postfix) with ESMTP id 4F30563281E
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 17:54:13 -0300 (ADT)
Received: by wwb13 with SMTP id 13so1393711wwb.19
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 13:54:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=i7yzV9KaVrffyF4pI9rnkc1mZX5X8hx9dpVO4KIrCvM=;
	b=MdJd9v0T3pTo0v99rdCaA7xH+E6yy6Zvx/Q63VUzlnPzBjrvOO4z91bV8m+XGDg2+7
	2BKDSp2Vf1okDwTkOhYoPdj7ufzOUUXmHQyztfJ5LJTE2CKfvh4SVFJYpiyTNACF2Jd2
	IZ38j6L14bvCUq1zrsTV6gHhRbS671s2lbfKk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=jIWI4TzzwcL8qy3ahOUdOiELgzmYvSCLrluoP4Hvnoynm5Y45078BERjvHGnF457dD
	gQc3fZUxzxZQYnqa+ybapoby+BeYlVjLPEWr10d8r6lhlG2vr93xpJ1v1QNYURBJhBt6
	mMaLiRiHS37RO/MzxuaqXndOnSQ1YDTGBC1Ac=
MIME-Version: 1.0
Received: by 10.227.142.139 with SMTP id q11mr7928118wbu.103.1282769651425;
	Wed, 25 Aug 2010 13:54:11 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Wed, 25 Aug 2010 13:54:11 -0700 (PDT)
In-Reply-To: <004a01cb43f9$ffb46040$6500a8c0@gibon>
References: <004a01cb43f9$ffb46040$6500a8c0@gibon>
Date: Wed, 25 Aug 2010 14:54:11 -0600
Message-ID: <AANLkTik35Gd_DSqhGQSNTUYkh8crY_mc_RDYoqYOzwVS@mail.gmail.com>
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
From: Scott Marlowe <scott.marlowe@gmail.com>
To: =?ISO-8859-1?Q?F=E1bio_Gibon_=2D_Comex_System?= <gibon@comexsystem.com.br>
Cc: PostgreSQL - mailing list <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/227
X-Sequence-Number: 35476

On Tue, Aug 24, 2010 at 8:05 PM, F=E1bio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> I'm having problems with connection time using Post 8.4 on Win 2008
> enterprise (32bits). To do open/close 10 connections i lost about 20 seco=
nds
> and doing the same test using Post 8.4 in another server (Win 2003) on 20
> seconds i get (open/close) almost 500 connections. The difference is very
> very large. Somebody did have any problem like this?

Also, are you running anything on one that you're not on the other,
like anti-virus software?  That can often get in the way of
performance too.



From scott.marlowe@gmail.com Wed Aug  25 21:47:12 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 8E9FF632BC9
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 18:47:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 16873-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 21:47:05 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id C1970632282
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 18:47:04 -0300 (ADT)
Received: by wyb35 with SMTP id 35so1215905wyb.19
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 14:47:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=0XqLsj06Q3Q2SdvjSQtGqxDY4/tzVJ/Q3spyQFcH0wI=;
	b=i7WKm7LM+SCmaaau9vMzF/YN7rITTKlMqyBp41Vjsg8jcEII6m7Qse2hJRv3uLX4z9
	pVIE65eVbQKJ0/tsuC+ikM/GxO/FVCVZC9EApEzGccz3W0YnnUGIZUoIf6b6Bp+lVuXr
	bepmjZEY7id1hThM4PNtjBQrm6p714pHfOgek=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=XE0i0PgzcCo7kLVKIOaCv0HmkQeNfGXkcptZZpHlk6AMngdJjktYPWfaaXber0je1K
	Tp50cwq+B0RbMGqeW0SAmcYUtIxhyNMXknvNQd6UUZ0dpjJr96kVjJZ/4AVNq+OHtgjg
	xSBlaorGj1cAIctCvi8Hvezq8muH/cc1pAgHk=
MIME-Version: 1.0
Received: by 10.227.156.143 with SMTP id x15mr7928676wbw.39.1282772822634;
	Wed, 25 Aug 2010 14:47:02 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Wed, 25 Aug 2010 14:47:02 -0700 (PDT)
In-Reply-To: <004a01cb43f9$ffb46040$6500a8c0@gibon>
References: <004a01cb43f9$ffb46040$6500a8c0@gibon>
Date: Wed, 25 Aug 2010 15:47:02 -0600
Message-ID: <AANLkTinJLCAdy-xftLow2odrnu6c9RDeD=1D5gwxh+Z_@mail.gmail.com>
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
From: Scott Marlowe <scott.marlowe@gmail.com>
To: =?ISO-8859-1?Q?F=E1bio_Gibon_=2D_Comex_System?= <gibon@comexsystem.com.br>
Cc: PostgreSQL - mailing list <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/228
X-Sequence-Number: 35477

On Tue, Aug 24, 2010 at 8:05 PM, F=E1bio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> I'm having problems with connection time using Post 8.4 on Win 2008
> enterprise (32bits). To do open/close 10 connections i lost about 20 seco=
nds
> and doing the same test using Post 8.4 in another server (Win 2003) on 20
> seconds i get (open/close) almost 500 connections. The difference is very
> very large. Somebody did have any problem like this?

Also, look into the QoS settings for the network stack.  Those have
produced problems before for pgsql.
--=20
To understand recursion, one must first understand recursion.



From gibon@comexsystem.com.br Wed Aug  25 23:45:59 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id A70F6632D2A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 20:45:59 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 61494-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 23:45:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ns3b.twi.com.br (ns3b.twi.com.br [201.87.225.54])
	by mail.postgresql.org (Postfix) with ESMTP id C3270632CE0
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 20:45:50 -0300 (ADT)
Received: (qmail 5248 invoked from network); 25 Aug 2010 20:44:12 -0300
Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[201.21.98.184])
	(envelope-sender <gibon@comexsystem.com.br>)
	by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP
	for <scott.marlowe@gmail.com>; 25 Aug 2010 20:44:12 -0300
Message-ID: <002401cb44af$a22f5e50$6500a8c0@gibon>
Reply-To: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
From: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?= <gibon@comexsystem.com.br>
To: "Scott Marlowe" <scott.marlowe@gmail.com>
Cc: "PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
References: <004a01cb43f9$ffb46040$6500a8c0@gibon>
	<AANLkTinJLCAdy-xftLow2odrnu6c9RDeD=1D5gwxh+Z_@mail.gmail.com>
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
Date: Wed, 25 Aug 2010 20:45:26 -0300
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.461 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, STOX_REPLY_TYPE=0.439
X-Spam-Level: 
X-Archive-Number: 201008/229
X-Sequence-Number: 35478

Thanks a lot... i will check this too.

Fábio Gibon
----- Original Message ----- 
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Fábio Gibon - Comex System" <gibon@comexsystem.com.br>
Cc: "PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
Sent: Wednesday, August 25, 2010 6:47 PM
Subject: Re: [ADMIN] PostgreSQL 8.4 x Win 2008 - slow connection


On Tue, Aug 24, 2010 at 8:05 PM, Fábio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> I'm having problems with connection time using Post 8.4 on Win 2008
> enterprise (32bits). To do open/close 10 connections i lost about 20 
> seconds
> and doing the same test using Post 8.4 in another server (Win 2003) on 20
> seconds i get (open/close) almost 500 connections. The difference is very
> very large. Somebody did have any problem like this?

Also, look into the QoS settings for the network stack.  Those have
produced problems before for pgsql.
-- 
To understand recursion, one must first understand recursion.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin