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
Hi,
I have a Centos 6.2 Virtual machine that contains Postgresql version 8.4
database. The application installed in this Virtual machine uses this database
that is local to this Virtual machine. I have tried to offload the database,
by installing it on a remote Virtual machine, on another ser