libpq or postgresql performance

From: Aryan Ariel Rodriguez Chalas <wimogan(at)yahoo(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: libpq or postgresql performance
Date: 2012-09-06 20:04:31
Message-ID: 1346961871.28573.YahooMailNeo@web124504.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I'm working with an application that connects to a remote server database using "libpq" library over internet, but making a simple query is really slow even though I've done PostgreSQL Tunning and table being indexed, so I want to know:

-Why is postgresql or libpq that slow when working over internet?
-What else should I do to solve this issue in addition of postgresql tunning?
-Why if I connect to the remote server desktop (using RDP or any Remote Desktop Application) and run the application using the same internet connection, it runs really fast when making requests to postgresql; but if I run the application locally by connecting to the remote postgresql server through "libpq", it's really slow?.

Thanks in advance,

Ariel Rodriguez

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message charles_xie 2012-09-07 01:50:11 Re: HELP!!!-----Need to Sql commands to monitoring Postgresql
Previous Message Steven Crandell 2012-09-06 19:50:18 Re: HELP!!!-----Need to Sql commands to monitoring Postgresql