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 server, and tried to
connect to it from my local Virtual machine. The application configuration
remains the same, only database is offloaded to a remote Virtual machine on
another server and the connection parameters have 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?
Please suggest.
Kind Regards,
Manoj Agarwal