Remote access to Postgresql slow
От | Manoj Agarwal |
---|---|
Тема | Remote access to Postgresql slow |
Дата | |
Msg-id | B8B643D9E7C05047A97289A119803D7905F954@assistback-1.assist.be обсуждение исходный текст |
Ответы |
Re: Remote access to Postgresql slow
Re: Remote access to Postgresql slow |
Список | pgsql-performance |
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
В списке pgsql-performance по дате отправления: