Skip site navigation (1) Skip section navigation (2)

Re: slowness in the connection

From: "Marie-Claude QUIDOZ" <Marie-Claude(dot)QUIDOZ(at)cefe(dot)cnrs(dot)fr>
To: "Marie-Claude QUIDOZ" <Marie-Claude(dot)QUIDOZ(at)cefe(dot)cnrs(dot)fr>, "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: slowness in the connection
Date: 2010-09-27 15:47:00
Message-ID: AE1706B5C143C44589513A92F5945DB767357D@ZZML.newcefe.newage.fr (view raw or flat)
Thread:
Lists: pgadmin-support
Hello

I find a solution

If I put the IP number (x.x.x.x) instead of the name of the server, the connection is speed.

Thanks

MCQ

-----Message d'origine-----
De : Marie-Claude QUIDOZ 
Envoyé : lundi 27 septembre 2010 15:32
À : Guillaume Lelarge
Cc : pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] slowness in the connection

Hello

Thanks for you answer

I dont'use SSL connection for my test

Yes It is particulary slow when I want connect me to a server (for example, when I click on "cnx-xxx". -cf file) or when I want open a database 

A+

MCQ


-----Message d'origine-----
De : pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] De la part de Guillaume Lelarge Envoyé : lundi 27 septembre 2010 13:30 À : Marie-Claude QUIDOZ Cc : pgadmin-support(at)postgresql(dot)org Objet : Re: [pgadmin-support] slowness in the connection

Le 27/09/2010 11:58, Marie-Claude QUIDOZ a écrit :
> Hello
> 
> I use 1.12.0 PGAdminIII from a client for seven windows connect to a 
> postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit 
> server (service pack 2). The connection is extremely slow.
> 
> Should we change a parameter in the configuration either Postgres or 
> pgAdmin?
> 

If the connection is slow, there's nothing you can do on PostgreSQL or pgAdmin. If you're using SSL connection, disabling it will have a good result on performance (but a bad one on security).

What do you exactly mean with connection? when you connect to a server?
when you use pgAdmin? when you launch queries?


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-09-27 15:49:47
Subject: Re: slowness in the connection
Previous:From: Michael ShapiroDate: 2010-09-27 15:27:09
Subject: Re: dropping connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group