Remote access to Postgresql slow

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

Responses

Browse pgsql-performance by date

  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