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: | 7be3f35d0706210801p732f2e73o147e3cbc0dc98153@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
"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
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 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!
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-06-21 15:09:07 | Re: Volunteer to build a configuration tool |
Previous Message | Ben Trewern | 2007-06-21 14:54:53 | Re: PostgreSQL Configuration Tool for Dummies |