Re: slowness in the connection - Mailing list pgadmin-support

From Marie-Claude QUIDOZ
Subject Re: slowness in the connection
Date
Msg-id AE1706B5C143C44589513A92F5945DB767357D@ZZML.newcefe.newage.fr
Whole thread Raw
In response to slowness in the connection  ("Marie-Claude QUIDOZ" <Marie-Claude.QUIDOZ@cefe.cnrs.fr>)
Responses Re: slowness in the connection  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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@postgresql.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
whenI want open a database  

A+

MCQ


-----Message d'origine-----
De : pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] De la part de Guillaume Lelarge
Envoyé :lundi 27 septembre 2010 13:30 À : Marie-Claude QUIDOZ Cc : pgadmin-support@postgresql.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,
disablingit 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?


--
Guillaumehttp://www.postgresql.frhttp://dalibo.com

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


pgadmin-support by date:

Previous
From: Michael Shapiro
Date:
Subject: Re: dropping connection
Next
From: Guillaume Lelarge
Date:
Subject: Re: slowness in the connection