Skip site navigation (1) Skip section navigation (2)

Re: Data transfer very slow when connected via DSL

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: "Rainer Bauer" <usenet(at)munnin(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-21 15:01:39
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Hello Rainer,

The database computer is connected via a 2MBit SDL connection. I myself have
> 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

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.


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

In response to


pgsql-performance by date

Next:From: Dave PageDate: 2007-06-21 15:09:07
Subject: Re: Volunteer to build a configuration tool
Previous:From: Ben TrewernDate: 2007-06-21 14:54:53
Subject: Re: PostgreSQL Configuration Tool for Dummies

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group