Re: libpq or postgresql performance

Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com> wrote:

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

define slow.

>
> -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
usingthe same internet connection, it runs really fast when making requests to postgresql; but if I run the application
locallyby connecting to the remote postgresql server through "libpq", it's really slow?. 

Maybe DNS-Resolving - Problems...


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°