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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-09-27 15:49:47 | Re: slowness in the connection |
Previous Message | Michael Shapiro | 2010-09-27 15:27:09 | Re: dropping connection |