On Fri, Sep 14, 2012 at 3:02 AM, Manoj Agarwal wrote:
> changed. The connection is all fine and the application can access the
> remote database.
>
> I have observed that the Postgresql is responding extremely slow. What
> should I do to improve its performance?
Are you connecting via host name
Is your network link between server and client across the public internet?
You need to check bandwidth and latency characteristics of your network.
A simple test run following on server host and run it again on the client
host.
time psql [connect details] -c 'select now()'
I access postgresql d
