The database computer is connected via a 2MBit SDL connection. I myself have
> 768/128 KBit ADSL connection and pinging the server takes 150ms on
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
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 Page||Date: 2007-06-21 15:09:07|
|Subject: Re: Volunteer to build a configuration tool|
|Previous:||From: Ben Trewern||Date: 2007-06-21 14:54:53|
|Subject: Re: PostgreSQL Configuration Tool for Dummies|