DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=Uso7aHHoci9FVnSdA0SzolnUsHOoeNTSlIjIW3jXfSp+FrJvt/ZWN2nNDsB4bcMO734PfI474sLY9RgPfLhumt7lKinx7YOHtqrKwIPYN4tVSd/UmmRSfxD9HFDiKf6dMlAeQTMf/4KDP8/cZBeOInt1ompakv+9Zy3ffvWroMI=;
Message-ID: <1346961871.28573.YahooMailNeo@web124504.mail.ne1.yahoo.com>
Date: Thu, 6 Sep 2012 13:04:31 -0700 (PDT)
From: Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
Reply-To: Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
Subject: libpq or postgresql performance
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hello,=0A=0AI'm working with an application that connects to a remote serve=
r database using "libpq" library over internet, but making a simple query i=
s really slow even though I've done PostgreSQL Tunning and table being inde=
xed, so I want to know:=0A=0A-Why is postgresql or libpq that slow when wor=
king over internet?=0A-What else should I do to solve this issue in additio=
n of postgresql tunning?=0A-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 p=
ostgresql; but if I run the application locally by connecting to the remote=
 postgresql server through "libpq", it's really slow?.=0A=0AThanks in advan=
ce,=0A=0AAriel Rodriguez=0A