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
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

In response to

Responses

Browse pgadmin-support by date

  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