| From: | "Manoj Agarwal" <ma(at)ockham(dot)be> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Remote access to Postgresql slow |
| Date: | 2012-09-14 09:02:09 |
| Message-ID: | B8B643D9E7C05047A97289A119803D7905F954@assistback-1.assist.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcos Ortiz | 2012-09-14 14:56:26 | Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets |
| Previous Message | Daniel Farina | 2012-09-14 08:45:32 | Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets |