Re: [PERFORM] Remote access to Postgresql slow

2012-09-15 Thread Scott Marlowe
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

Re: [PERFORM] Remote access to Postgresql slow

2012-09-15 Thread Andrew Barnham
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

[PERFORM] Remote access to Postgresql slow

2012-09-15 Thread Manoj Agarwal
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