pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 8.4 x Win 2008 - slow connection
6+ messages / 2 participants
[nested] [flat]
* PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 02:05 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 3 replies; 6+ messages in thread
From: Fábio Gibon - Comex System @ 2010-08-25 02:05 UTC (permalink / raw)
To: pgsql-admin
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ábio Henrique Gibon
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 03:44 Scott Marlowe <scott.marlowe@gmail.com>
parent: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2010-08-25 03:44 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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?
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 17:06 Scott Marlowe <scott.marlowe@gmail.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2010-08-25 17:06 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; pgsql-admin
Please keep the list cc'd to your replies
On Wed, Aug 25, 2010 at 6:22 AM, Fábio Gibon - Comex System
<gibon@comexsystem.com.br> wrote:
> Tks Scott...
> but I did tests connecting by network and local, both was very
> slowly.
That in no way proves it's not a network problem.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 20:54 Scott Marlowe <scott.marlowe@gmail.com>
parent: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2010-08-25 20:54 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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, 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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 21:47 Scott Marlowe <scott.marlowe@gmail.com>
parent: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2010-08-25 21:47 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 8.4 x Win 2008 - slow connection
@ 2010-08-25 23:45 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Fábio Gibon - Comex System @ 2010-08-25 23:45 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-08-25 23:45 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-25 02:05 PostgreSQL 8.4 x Win 2008 - slow connection Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2010-08-25 03:44 ` Re: PostgreSQL 8.4 x Win 2008 - slow connection Scott Marlowe <scott.marlowe@gmail.com>
2010-08-25 17:06 ` Re: PostgreSQL 8.4 x Win 2008 - slow connection Scott Marlowe <scott.marlowe@gmail.com>
2010-08-25 20:54 ` Re: PostgreSQL 8.4 x Win 2008 - slow connection Scott Marlowe <scott.marlowe@gmail.com>
2010-08-25 21:47 ` Re: PostgreSQL 8.4 x Win 2008 - slow connection Scott Marlowe <scott.marlowe@gmail.com>
2010-08-25 23:45 ` Re: PostgreSQL 8.4 x Win 2008 - slow connection Fábio Gibon - Comex System <gibon@comexsystem.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox