Postgres Pro
Downloads
Home   >   mailing lists

Re: dblink_connect is slow - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: dblink_connect is slow
Date
Msg-id 4BBB5A530200002500030517@gw.wicourts.gov
Whole thread Raw
In response to dblink_connect is slow  (scheu dba <scheu.postgresql@gmail.com>)
List pgsql-admin
Tree view 
scheu dba <scheu.postgresql@gmail.com> wrote:

> - when remote_server entry exists in /etc/hosts file, the
> connexionis immediate
> - but when remote_server entry does not exists in /etc/hosts file,
> the connexion take 1 minute

You might want to check that the server has a reverse DNS entry (to
map the IP address back to a server name).

-Kevin

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Configuration questions
Next
From: "Kevin Grittner"
Date:
Subject: Re: Database level encryption