psql is too slow to connect

Started by eroblesover 14 years ago3 messagesgeneral
Jump to latest
#1erobles
erobles@sensacd.com.mx

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 exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no 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 the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and 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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: erobles (#1)
Re: psql is too slow to connect

"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

#3Rob Sargent
robjsargent@gmail.com
In reply to: Tom Lane (#2)
Re: psql is too slow to connect

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