From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-performance@postgresql.org
Subject: Re: libpq or postgresql performance
Date: Fri, 7 Sep 2012 07:35:34 +0200
Message-ID: <20120907053534.GA7707@tux> (raw)
In-Reply-To: <1346961871.28573.YahooMailNeo@web124504.mail.ne1.yahoo.com>
References: <1346961871.28573.YahooMailNeo@web124504.mail.ne1.yahoo.com>
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 making a 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 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?.
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°
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: akretschmer@spamfence.net
Subject: Re: libpq or postgresql performance
In-Reply-To: <20120907053534.GA7707@tux>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox