Обсуждение: psql is too slow to connect

Поиск
Список
Период
Сортировка

psql is too slow to connect

От
"Ing.Edmundo.Robles.Lopez"
Дата:
Hi, I have a problem with psql, is very slow to connect. I Checked the
status of my network and the server and the client respond ok.

Any other ideas?
Perhaps, should  i need review, connections, shared memory, or  if a big
  table  is being accessed??
El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido
exclusivamentea su destinatario.  No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de
estainformación por un receptor o entidades distintas al destinatario.  Si recibe este correo sin ser el destinatario
sele solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o
comunicacionesno autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico. 

The content of this email and its attached files are private and confidential and intended exclusively for the use of
theindividual or entity to which they are addressed. The retransmission, dissemination, or any other use of this
informationother than by the intended recipient is prohibited.  If you have received this email in error please delete
itand notify the sender.  The company cannot be held liable for unauthorized electronic transmissions or
communications,nor for those emitted by non-company individuals and entities. 

Re: psql is too slow to connect

От
Tom Lane
Дата:
"Ing.Edmundo.Robles.Lopez" <erobles@sensacd.com.mx> writes:
> Hi, I have a problem with psql, is very slow to connect. I Checked the
> status of my network and the server and the client respond ok.

First thing that comes to mind is DNS lookup problems.  It's hard to
speculate more than that on such little information.

            regards, tom lane

Re: psql is too slow to connect

От
Rob Sargent
Дата:

On 11/04/2011 12:08 PM, Tom Lane wrote:
> "Ing.Edmundo.Robles.Lopez" <erobles@sensacd.com.mx> writes:
>> Hi, I have a problem with psql, is very slow to connect. I Checked the
>> status of my network and the server and the client respond ok.
>
> First thing that comes to mind is DNS lookup problems.  It's hard to
> speculate more than that on such little information.
>
>             regards, tom lane
>
Others have found their ".psqlrc" file had expensive look-ups