Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id BB0C79FB90B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 21 Jun 2007 12:01:47 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 67603-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 21 Jun 2007 12:01:44 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.183])
	by postgresql.org (Postfix) with ESMTP id 46DE09FA5A0
	for <pgsql-performance@postgresql.org>;
	Thu, 21 Jun 2007 12:01:43 -0300 (ADT)
Received: by wa-out-1112.google.com with SMTP id k40so395502wah
	for <pgsql-performance@postgresql.org>;
	Thu, 21 Jun 2007 08:01:39 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=Jb0CuituPWN2epcMhhHA4Oe+hc+6QcIvi4og0DqKBdonzIrdRW9AEhW4X0mL6FZ1NeYRsTq4SRPJ1K29hnjhPvxWtj7AndTIEYkgGSQPdiWgz5l2oxto0So/x9LoKjgYTCJXm7u6qc+JyjEeksm+1oC71m5ZEvGZHUKIdTW4Re4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=K7ttbJctz+RGKGT38SGXUAb7h/rCO2bJS1BjOo0WiqUi6RW7ZtjLDfzbGSZCcwSO8i0VTq4b+FSOuqUrPUn4bLiJAgyyoEGT/NZP6n/FMe6poRoH0dAC8QqByy2Ni2/QlU8sKnVZpwFlWq7KRCw0/uheV0D7xwtmYx3Tp7/RiK0=
Received: by 10.114.106.1 with SMTP id e1mr1692499wac.1182438099411;
	Thu, 21 Jun 2007 08:01:39 -0700 (PDT)
Received: by 10.114.112.16 with HTTP; Thu, 21 Jun 2007 08:01:39 -0700 (PDT)
Message-ID: <7be3f35d0706210801p732f2e73o147e3cbc0dc98153@mail.gmail.com>
Date: Thu, 21 Jun 2007 17:01:39 +0200
From: "Harald Armin Massa" <haraldarminmassa@gmail.com>
To: "Rainer Bauer" <usenet@munnin.com>
Subject: Re: Data transfer very slow when connected via DSL
Cc: pgsql-performance@postgresql.org
In-Reply-To: <s7tk73d57kvb3f4ph1kmkvhdfe0kak5a1r@4ax.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_102423_10387393.1182438099391"
References: <s7tk73d57kvb3f4ph1kmkvhdfe0kak5a1r@4ax.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/465
X-Sequence-Number: 25498

------=_Part_102423_10387393.1182438099391
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello Rainer,

The database computer is connected via a 2MBit SDL connection. I myself hav=
e
> a
> 768/128 KBit ADSL connection and pinging the server takes 150ms on
> average.
>

I do not have a solution, but I can confirm the problem :)

One PostgreSQL-Installation: Server 8.1 and 8.2 on Windows in the central;
various others connected via VPN. Queries are subsecond when run locally
(including data transfer), and up to 10 seconds and more via VPN, even in
"off-hours"

The data-transfer is done via PG-Admin or via psycopg2 Python-Database
adapter; nothing with ODBC or similiar in between.

I did not find a solution so far; and for bulk data transfers I now
programmed a workaround.

Harald

--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Stra=DFe 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July
to Wednesday 11th July. See you there!

------=_Part_102423_10387393.1182438099391
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello Rainer,<br><br><div><blockquote class=3D"gmail_quote" style=3D"border=
-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-lef=
t: 1ex;">The database computer is connected via a 2MBit SDL connection. I m=
yself have a
<br>768/128 KBit ADSL connection and pinging the server takes 150ms on aver=
age.<br></blockquote></div><br>I do not have a solution, but I can confirm =
the problem :)<br><br>One PostgreSQL-Installation: Server 8.1 and 8.2 on Wi=
ndows in the central; various others connected via VPN. Queries are subseco=
nd when run locally (including data transfer), and up to 10 seconds and mor=
e via VPN, even in &quot;off-hours&quot;
<br><br>The data-transfer is done via PG-Admin or via psycopg2 Python-Datab=
ase adapter; nothing with ODBC or similiar in between.<br><br>I did not fin=
d a solution so far; and for bulk data transfers I now programmed a workaro=
und.
<br><br>Harald<br><br>-- <br>GHUM Harald Massa<br>persuadere et programmare=
<br>Harald Armin Massa<br>Spielberger Stra=DFe 49<br>70435 Stuttgart<br>017=
3/9409607<br>fx 01212-5-13695179 <br>-<br>EuroPython 2007 will take place i=
n Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you t=
here!
<br>

------=_Part_102423_10387393.1182438099391--